DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on MTL_TRANSACTION_LOT_NUMBERS

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

1476: /*==========================================================================*
1477: | Procedure : INV_LOT_SERIAL_INSERT |
1478: | |
1479: | Description : This API will be called by INV create_logical_transactions |
1480: | API to do a bulk insert into mtl_transaction_lot_numbers if|
1481: | the item is lot control and insert into |
1482: | mtl_unit_transactions if the item is serial control. |
1483: | |
1484: | Input Parameters : |

Line 1639: FROM mtl_transaction_lot_numbers

1635: ATTRIBUTE12,
1636: ATTRIBUTE13,
1637: ATTRIBUTE14,
1638: ATTRIBUTE15
1639: FROM mtl_transaction_lot_numbers
1640: WHERE transaction_id = p_transaction_id;
1641:
1642: BEGIN
1643:

Line 1698: INSERT INTO mtl_transaction_lot_numbers

1694: end;
1695:
1696: -- insert into mtln same as the one of parent transaction id
1697: -- with the logical intercompany issue type
1698: INSERT INTO mtl_transaction_lot_numbers
1699: ( TRANSACTION_ID
1700: ,LAST_UPDATE_DATE
1701: ,LAST_UPDATED_BY
1702: ,CREATION_DATE