DBA Data[Home] [Help]

APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 803: SELECT mtl_material_transactions_s.nextval

799: WHERE Organization_id = p_organization_id
800: AND Inventory_item_id = p_inventory_item_id AND uom_code = p_uom;
801:
802: CURSOR l_transaction_header_id_csr IS
803: SELECT mtl_material_transactions_s.nextval
804: FROM dual;
805:
806:
807: CURSOR l_acct_period_csr is

Line 1641: SELECT mtl_material_transactions_s.nextval

1637: select transaction_temp_id, fm_serial_number, to_serial_number, serial_prefix from mtl_serial_numbers_temp
1638: where transaction_temp_id = l_transaction_temp_id;
1639:
1640: Cursor l_Get_txn_header_id_csr IS
1641: SELECT mtl_material_transactions_s.nextval
1642: FROM dual;
1643:
1644: Cursor l_Get_Mo_Header_id_csr(l_line_id NUMBER) IS
1645: select distinct header_id from csp_moveorder_lines