DBA Data[Home] [Help]

APPS.INV_TRANSACTION_FLOW_PVT dependencies on MTL_CATEGORIES_V

Line 94: mtl_categories_v mcv,

90: SELECT 1 INTO l_count FROM DUAL
91: WHERE P_QUALIFIER_VALUE_ID IN(
92: SELECT mcv.category_id
93: FROM
94: mtl_categories_v mcv,
95: MTL_CATEGORY_SET_VALID_CATS MCSVC,
96: MTL_CATEGORY_SETS_b mcs
97: WHERE
98: mcs.category_set_id = decode(p_flow_type,1,1,2)

Line 104: FROM mtl_categories_v mcv,

100: and mcs.category_set_id = MCSVC.category_set_id
101: and MCSVC.category_id = mcv.category_id
102: UNION
103: SELECT mcv.category_id
104: FROM mtl_categories_v mcv,
105: MTL_CATEGORY_SETS_b mcs
106: WHERE
107: mcs.category_set_id = decode(p_flow_type,1,1,2)
108: and mcs.structure_id = mcv.structure_id