Home » Applications » Oracle Fusion Apps & E-Business Suite » otn delivery number
otn delivery number [message #294308] Thu, 17 January 2008 03:19 Go to next message
annu-agi
Messages: 238
Registered: July 2005
Location: Karachi
Senior Member

hi experts

see the attachment file first .. i cant find that number is there anyone can help me where is this feild located and table name

regards

anwer
  • Attachment: dc1.JPG
    (Size: 158.81KB, Downloaded 681 times)
Re: otn delivery number [message #294332 is a reply to message #294308] Thu, 17 January 2008 04:36 Go to previous messageGo to next message
jayaharan76
Messages: 62
Registered: June 2006
Location: BANGALORE
Member

Hello,

Delivery numbers would be created during pick release process.
(generation of the Pick wave move order).You need to check the pick release API .

Would appreciate, If you can share your exact requirement

Thanks
Jayaharan Krishnamurthy
Jayaharan76@yahoo.com


Re: otn delivery number [message #294404 is a reply to message #294332] Thu, 17 January 2008 08:11 Go to previous message
annu-agi
Messages: 238
Registered: July 2005
Location: Karachi
Senior Member

thanks
jaya


my exact requirment is just to find simply the delivery number which is you could see in a picture and i just found that number in WSH_DSNO_ITEM_DETAILS_V. actually i m customising some reports so that is why i need this document number in reference.

Thanks
Anyway

if you can tell me one more thing that is confusing very much
in inventory we want to maintain serialize inventory for that we record every item serial in Materrial Receive. but while delivering fully or partially delivering we cannot store any data regarding serial number ..how it possible to maintain exact item serial no. suggust me....

for an example

item : IP-PHONE ====QTY ====10 ===SERIAL NO 1900001 TO 190010

that is receive in material receive but when we are issuing this in partial delivery lets suppose 4 PCS 1900004 to 190008 we delivered then we have 6 pcs in hand with respective serial numbers.



how can we do this...???


regards

anwer
Previous Topic: Analogue of database triggers in apps
Next Topic: chart Of Accounts and TB
Goto Forum:
  


Current Time: Fri Jun 28 23:32:26 CDT 2024