DBA Data[Home] [Help]

APPS.INV_TRANSACTION_FLOW_PVT dependencies on MTL_CATEGORY_SETS_B

Line 96: MTL_CATEGORY_SETS_b mcs

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)
99: and mcs.structure_id = mcv.structure_id
100: and mcs.category_set_id = MCSVC.category_set_id

Line 105: MTL_CATEGORY_SETS_b mcs

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
109: and mcs.default_category_id = mcv.category_id