DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1177: | API to do a bulk insert into MTL_MATERIAL_TRANSACTIONS |

1173: /*==========================================================================*
1174: | Procedure : INV_MMT_INSERT |
1175: | |
1176: | Description : This API will be called by INV create logical transactions |
1177: | API to do a bulk insert into MTL_MATERIAL_TRANSACTIONS |
1178: | table. |
1179: | |
1180: | Input Parameters : |
1181: | p_api_version_number - API version number |

Line 1295: INTO MTL_MATERIAL_TRANSACTIONS

1291: END IF;
1292:
1293:
1294: INSERT
1295: INTO MTL_MATERIAL_TRANSACTIONS
1296: ( TRANSACTION_ID
1297: ,ORGANIZATION_ID
1298: ,INVENTORY_ITEM_ID
1299: ,REVISION

Line 1630: SELECT mtl_material_transactions_s.nextval

1626: END IF;
1627:
1628: IF (p_lot_control_code = 2) THEN
1629: IF (p_serial_control_code in (2, 5, 6)) THEN
1630: SELECT mtl_material_transactions_s.nextval
1631: INTO l_serial_transaction_id
1632: FROM dual;
1633: ELSE
1634: l_serial_transaction_id := null;