APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

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

1191: /*==========================================================================*
1192: | Procedure : INV_MMT_INSERT |
1193: | |
1194: | Description : This API will be called by INV create logical transactions |
1195: | API to do a bulk insert into MTL_MATERIAL_TRANSACTIONS |
1196: | table. |
1197: | |
1198: | Input Parameters : |
1199: | p_api_version_number - API version number |

Line 1313: INTO MTL_MATERIAL_TRANSACTIONS

1309: END IF;
1310:
1311:
1312: INSERT
1313: INTO MTL_MATERIAL_TRANSACTIONS
1314: ( TRANSACTION_ID
1315: ,ORGANIZATION_ID
1316: ,INVENTORY_ITEM_ID
1317: ,REVISION

Line 1656: SELECT mtl_material_transactions_s.nextval

1652: END IF;
1653:
1654: IF (p_lot_control_code = 2) THEN
1655: IF (p_serial_control_code in (2, 5, 6)) THEN
1656: SELECT mtl_material_transactions_s.nextval
1657: INTO l_serial_transaction_id
1658: FROM dual;
1659: ELSE
1660: l_serial_transaction_id := null;

Line 1685: from mtl_material_transactions

1681: l_mmt_pri_qty,
1682: l_mmt_src_id,
1683: l_mmt_src_type_id,
1684: l_mmt_src_name
1685: from mtl_material_transactions
1686: where transaction_id = p_transaction_id;
1687: exception
1688: when others then
1689: l_mmt_src_id := l_mtln.TRANSACTION_SOURCE_ID;