OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Populate MTL_TRANSACTION_LOTS

Home » Applications » Oracle Fusion Apps & E-Business Suite » Populate MTL_TRANSACTION_LOTS_INTERFACE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 00:57:37 CDT 2024