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
annu-agi
Messages: 238
Registered: July 2005
Location: Karachi
Senior Member
Dear
Experts


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

regards



anwer
  • Attachment: serial.JPG
    (Size: 146.19KB, Downloaded 803 times)

Report message to a moderator

Re: Serial No On Shipment Document [message #299526 is a reply to message #297435] Tue, 12 February 2008 05:47 Go to previous message
vishal_ppa
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.

Report message to a moderator

Previous Topic: ZebraDesigner API? for WMS help...
Next Topic: Serial Number
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 06:23:31 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.