APPS.INV_SHORTCHECKPROCESSTRX_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 39: SELECT /*+ INDEX (mmt mtl_material_transactions_n5) */

35: L_seq_num NUMBER;
36: L_conc_status BOOLEAN;
37: --
38: CURSOR L_SelectTrx_csr (l_days in number )IS
39: SELECT /*+ INDEX (mmt mtl_material_transactions_n5) */
40: organization_id,
41: inventory_item_id
42: FROM mtl_material_transactions
43: WHERE shortage_process_code = 1

Line 42: FROM mtl_material_transactions

38: CURSOR L_SelectTrx_csr (l_days in number )IS
39: SELECT /*+ INDEX (mmt mtl_material_transactions_n5) */
40: organization_id,
41: inventory_item_id
42: FROM mtl_material_transactions
43: WHERE shortage_process_code = 1
44: and transaction_date > (sysdate - l_days )
45: GROUP BY organization_id,
46: inventory_item_id;

Line 56: FROM mtl_material_transactions

52: -- higher quantity is choosen
53: CURSOR L_LastTrx_csr ( p_inventory_item_id IN NUMBER,
54: p_organization_id IN NUMBER ) IS
55: SELECT primary_quantity
56: FROM mtl_material_transactions
57: WHERE inventory_item_id = p_inventory_item_id
58: AND organization_id = p_organization_id
59: AND shortage_process_code = 1
60: ORDER BY transaction_date DESC,

Line 72: UPDATE mtl_material_transactions

68: p_inventory_item_id IN NUMBER,
69: p_shortage_process_code IN NUMBER )
70: IS
71: BEGIN
72: UPDATE mtl_material_transactions
73: SET shortage_process_code = p_shortage_process_code
74: WHERE organization_id = p_organization_id
75: AND inventory_item_id = p_inventory_item_id
76: AND shortage_process_code = 1;