DBA Data[Home] [Help]

APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 1020: -- 2. If applicable, inserts into MTL_TRANSACTION_LOTS_INTERFACE

1016: --
1017: -- We are performing all the below activities here
1018: --
1019: -- 1. Inserts into the MTL_TRANSACTIONS_INTERFACE
1020: -- 2. If applicable, inserts into MTL_TRANSACTION_LOTS_INTERFACE
1021: -- and MTL_SERIAL_NUMBERS_INTERFACE
1022: -- 3. Invokes the MTL_ONLINE_TRANSACTION_PUB.PROCESS_ONLINE proc to do the
1023: -- transaction processing.
1024: -- 4. Calls WRITE_BACK proc to write the result of the transaction processor

Line 1309: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE (

1305: END IF;
1306:
1307: IF l_lot_control_code = 2 THEN
1308:
1309: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE (
1310: TRANSACTION_INTERFACE_ID,
1311: SERIAL_TRANSACTION_TEMP_ID,
1312: LOT_NUMBER,
1313: TRANSACTION_QUANTITY,

Line 2379: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE (

2375: END IF;
2376:
2377: IF l_lot_control_code = 2 THEN
2378:
2379: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE (
2380: TRANSACTION_INTERFACE_ID,
2381: SERIAL_TRANSACTION_TEMP_ID,
2382: LOT_NUMBER,
2383: TRANSACTION_QUANTITY,