Home » Applications » Oracle Fusion Apps & E-Business Suite » Populate MTL_TRANSACTION_LOTS_INTERFACE
Populate MTL_TRANSACTION_LOTS_INTERFACE [message #217478] Fri, 02 February 2007 07:41
asha123
Messages: 23
Registered: November 2006
Location: Jordan
Junior Member
Hi ALL,

I am having problem with populating MTL_TRANSACTION_LOTS_INTERFACE,

I know that:

For every MTL_TRANSACTIONS_INTERFACE.TRANSACTION_INTERFACE_ID record
there should be one record matching the
MTL_TRANSACTION_LOTS_INTERFACE.TRANSACTION_INTERFACE_ID.

IF I populate the MTL_TRANSACTIONS_INTERFACE with the sequence (inv.MTL_MATERIAL_TRANSACTIONS_S.nextval ) then how I can give the same ID for LOTS (TRANSACTION_INTERFACE_ID)

I mean what is the right way to make them both get the same Id using sequence or what ever??

Many thanks in advance

Ahmad
Previous Topic: Making a Field as Mandatory in Forms
Next Topic: sub-inventory transferring using lpn
Goto Forum:
  


Current Time: Wed Dec 25 01:19:06 CST 2024