APPS.PO_INV_THIRD_PARTY_STOCK_MDTR dependencies on MTL_MATERIAL_TRANSACTIONS

Line 26: --| on MTL_MATERIAL_TRANSACTIONS and |

22: --| in order to avoid dependency of PO on INV |
23: --| 12/09/02 vchu Modified |
24: --| Replaced empty stub of consumption_trans_exist() |
25: --| with actual implmentation which has dependencies |
26: --| on MTL_MATERIAL_TRANSACTIONS and |
27: --| MTL_CONSUMPTION_TRANSACTIONS tables |
28: --| 12/12/02 vma Added empty stub of two functions |
29: --| Supplier_Owns_Tps and Sup_Site_Owns_Tps |
30: --| 12/12/02 vma Replace empty stub of Supplier_Owns_Tps and |

Line 71: mtl_material_transactions mmt

67:
68: CURSOR c_item_id IS
69: SELECT /*+FIRST_ROWS */ 1
70: FROM mtl_consumption_transactions mct,
71: mtl_material_transactions mmt
72: WHERE mmt.transaction_id = mct.transaction_id
73: AND mmt.transaction_source_id = p_transaction_source_id
74: AND mmt.inventory_item_id = p_item_id
75: AND Nvl(mct.consumption_processed_flag,'N') <> 'Y';

Line 80: mtl_material_transactions mmt

76:
77: CURSOR c_item_id_null IS
78: SELECT /*+FIRST_ROWS */ 1
79: FROM mtl_consumption_transactions mct,
80: mtl_material_transactions mmt
81: WHERE mmt.transaction_id = mct.transaction_id
82: AND mmt.transaction_source_id = p_transaction_source_id
83: AND Nvl(mct.consumption_processed_flag,'N') <> 'Y';
84:

Line 108: MTL_MATERIAL_TRANSACTIONS MMT

104: INTO l_count_cons_trans
105: FROM dual
106: WHERE EXISTS(SELECT 'Y'
107: FROM MTL_CONSUMPTION_TRANSACTIONS MCT,
108: MTL_MATERIAL_TRANSACTIONS MMT
109: WHERE MMT.TRANSACTION_ID = MCT.TRANSACTION_ID
110: AND MMT.TRANSACTION_SOURCE_ID = p_transaction_source_id
111: AND MMT.INVENTORY_ITEM_ID = p_item_id
112: AND nvl(MCT.CONSUMPTION_PROCESSED_FLAG, 'N') <> 'Y');

Line 119: MTL_MATERIAL_TRANSACTIONS MMT

115: INTO l_count_cons_trans
116: FROM dual
117: WHERE EXISTS(SELECT 'Y'
118: FROM MTL_CONSUMPTION_TRANSACTIONS MCT,
119: MTL_MATERIAL_TRANSACTIONS MMT
120: WHERE MMT.TRANSACTION_ID = MCT.TRANSACTION_ID
121: AND MMT.TRANSACTION_SOURCE_ID = p_transaction_source_id
122: AND nvl(MCT.CONSUMPTION_PROCESSED_FLAG, 'N') <> 'Y');
123: