Home » Applications » Oracle Fusion Apps & E-Business Suite » Serial No On Shipment Document (11i)
Serial No On Shipment Document [message #297435] Thu, 31 January 2008 10:00 Go to next message
Messages: 198
Registered: July 2005
Location: Karachi
Senior Member


i am customizing delivery chalan document and i made it almost, just one thing remains that the serial no of the particular item that exist on shipment document.
i know the main table of serial numbers but i cant find the relation b/w mtl_item_serial and oe_order_lines_all with flow_status_code='CLOSED' reference to inventory_item_id.

what i have tried that i can find all the serial no related to the item_cd but not that particular item_cd which exist on shipment document ..
please help me out .. i m really helpless..
*** see the JPEG for more detail view



  • Attachment: serial.JPG
    (Size: 146.19KB, Downloaded 147 times)
Re: Serial No On Shipment Document [message #299526 is a reply to message #297435] Tue, 12 February 2008 05:47 Go to previous message
Messages: 3
Registered: October 2007
Junior Member
Use OE_LOT_SERIAL_NUMBERS to make the join with OE_ORDER_LINES_ALL with column line_id. Hope this will resolve your issue.
Previous Topic: ZebraDesigner API? for WMS help...
Next Topic: Serial Number
Goto Forum:

Current Time: Sat Oct 22 13:55:25 CDT 2016

Total time taken to generate the page: 0.14656 seconds