APPS.GME_API_PUB dependencies on MTL_MATERIAL_TRANSACTIONS

Line 4030: FROM mtl_material_transactions mmt, gme_material_details mtl

4026: x_lpn_txns NUMBER;
4027: l_continue_lpn_txn VARCHAR2(1);
4028: CURSOR get_lpn_txns(p_batch_id IN NUMBER) IS
4029: SELECT COUNT(1)
4030: FROM mtl_material_transactions mmt, gme_material_details mtl
4031: WHERE NVL(transfer_lpn_id,0) > 0
4032: AND TRANSACTION_SOURCE_ID = p_batch_id
4033: AND transaction_action_id = 31
4034: AND transaction_type_id IN (44, 1002)

Line 5050: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE

5046: ,p_line_type IN NUMBER := NULL
5047: ,p_create_lot IN VARCHAR2 := NULL
5048: ,p_generate_lot IN VARCHAR2 := NULL
5049: ,p_generate_parent_lot IN VARCHAR2 := NULL
5050: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE
5051: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl)
5052: IS
5053: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER)
5054: IS

Line 5062: FROM mtl_material_transactions

5058:
5059: CURSOR cur_get_trans (v_header_id IN NUMBER)
5060: IS
5061: SELECT *
5062: FROM mtl_material_transactions
5063: WHERE transaction_set_id = v_header_id;
5064:
5065: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_MATERIAL_TXN';
5066: l_mmti_rec mtl_transactions_interface%ROWTYPE;

Line 5602: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE

5598: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
5599: ,p_create_lot IN VARCHAR2 := NULL
5600: ,p_generate_lot IN VARCHAR2 := NULL
5601: ,p_generate_parent_lot IN VARCHAR2 := NULL
5602: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE
5603: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl)
5604: IS
5605: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER)
5606: IS

Line 5614: FROM mtl_material_transactions

5610:
5611: CURSOR cur_get_trans (v_header_id IN NUMBER)
5612: IS
5613: SELECT *
5614: FROM mtl_material_transactions
5615: WHERE transaction_set_id = v_header_id;
5616:
5617: CURSOR cur_trans_org (v_transaction_id IN NUMBER)
5618: IS

Line 5620: FROM mtl_material_transactions

5616:
5617: CURSOR cur_trans_org (v_transaction_id IN NUMBER)
5618: IS
5619: SELECT organization_id, transaction_source_id, trx_source_line_id, transaction_type_id
5620: FROM mtl_material_transactions
5621: WHERE transaction_id = v_transaction_id;
5622:
5623: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN';
5624: l_transaction_id NUMBER;

Line 5625: l_mmt_rec mtl_material_transactions%ROWTYPE;

5621: WHERE transaction_id = v_transaction_id;
5622:
5623: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN';
5624: l_transaction_id NUMBER;
5625: l_mmt_rec mtl_material_transactions%ROWTYPE;
5626: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
5627: l_mmti_rec mtl_transactions_interface%ROWTYPE;
5628: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
5629: l_mat_dtl_rec gme_material_details%ROWTYPE;

Line 5966: FROM mtl_material_transactions

5962:
5963: CURSOR cur_trans_org (v_transaction_id IN NUMBER)
5964: IS
5965: SELECT organization_id
5966: FROM mtl_material_transactions
5967: WHERE transaction_id = v_transaction_id;
5968: BEGIN
5969: IF (g_debug <> -1) THEN
5970: gme_debug.log_initialize ('DeleteTxn');

Line 9835: FROM mtl_material_transactions mmt, gme_material_details mtl

9831: x_lpn_txns NUMBER;
9832: l_continue_lpn_txn VARCHAR2(1);
9833: CURSOR get_lpn_txns(p_batch_id IN NUMBER) IS
9834: SELECT COUNT(1)
9835: FROM mtl_material_transactions mmt, gme_material_details mtl
9836: WHERE NVL(transfer_lpn_id,0) > 0
9837: AND TRANSACTION_SOURCE_ID = p_batch_id
9838: AND transaction_action_id = 31
9839: AND transaction_type_id IN (44, 1002)