APPS.PO_INV_THIRD_PARTY_STOCK_MDTR dependencies on DUAL

Line 73: FROM dual

69: IF(p_item_id IS NOT NULL)
70: THEN
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

Line 84: FROM dual

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