DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 1462: | API to do a bulk insert into mtl_transaction_lot_numbers if|

1458: /*==========================================================================*
1459: | Procedure : INV_LOT_SERIAL_INSERT |
1460: | |
1461: | Description : This API will be called by INV create_logical_transactions |
1462: | API to do a bulk insert into mtl_transaction_lot_numbers if|
1463: | the item is lot control and insert into |
1464: | mtl_unit_transactions if the item is serial control. |
1465: | |
1466: | Input Parameters : |

Line 1614: FROM mtl_transaction_lot_numbers

1610: ATTRIBUTE12,
1611: ATTRIBUTE13,
1612: ATTRIBUTE14,
1613: ATTRIBUTE15
1614: FROM mtl_transaction_lot_numbers
1615: WHERE transaction_id = p_transaction_id;
1616: BEGIN
1617:
1618: IF (l_debug = 1) THEN

Line 1648: INSERT INTO mtl_transaction_lot_numbers

1644: END IF;
1645:
1646: -- insert into mtln same as the one of parent transaction id
1647: -- with the logical intercompany issue type
1648: INSERT INTO mtl_transaction_lot_numbers
1649: ( TRANSACTION_ID
1650: ,LAST_UPDATE_DATE
1651: ,LAST_UPDATED_BY
1652: ,CREATION_DATE