DBA Data[Home] [Help]

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 76: MTL_MATERIAL_TRANSACTIONS MMT

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
80: AND nvl(MCT.CONSUMPTION_PROCESSED_FLAG, 'N') <> 'Y');

Line 87: MTL_MATERIAL_TRANSACTIONS MMT

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');
91: END IF;