APPS.PO_INV_THIRD_PARTY_STOCK_MDTR dependencies on MTL_CONSUMPTION_TRANSACTIONS

Line 27: --| MTL_CONSUMPTION_TRANSACTIONS tables |

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 |
31: --| Sup_Site_Owns_Tps with actual implementation |

Line 75: FROM MTL_CONSUMPTION_TRANSACTIONS MCT,

71: SELECT count('Y')
72: INTO l_count_cons_trans
73: FROM dual
74: WHERE EXISTS(SELECT 'Y'
75: FROM MTL_CONSUMPTION_TRANSACTIONS MCT,
76: MTL_MATERIAL_TRANSACTIONS MMT
77: WHERE MMT.TRANSACTION_ID = MCT.TRANSACTION_ID
78: AND MMT.TRANSACTION_SOURCE_ID = p_transaction_source_id
79: AND MMT.INVENTORY_ITEM_ID = p_item_id

Line 86: FROM MTL_CONSUMPTION_TRANSACTIONS MCT,

82: SELECT count('Y')
83: INTO l_count_cons_trans
84: FROM dual
85: WHERE EXISTS(SELECT 'Y'
86: FROM MTL_CONSUMPTION_TRANSACTIONS MCT,
87: MTL_MATERIAL_TRANSACTIONS MMT
88: WHERE MMT.TRANSACTION_ID = MCT.TRANSACTION_ID
89: AND MMT.TRANSACTION_SOURCE_ID = p_transaction_source_id
90: AND nvl(MCT.CONSUMPTION_PROCESSED_FLAG, 'N') <> 'Y');