APPS.PO_R12_CAT_UPG_EXISTING_DOCS dependencies on ICX_CAT_PURCHASING_CAT_MAP_V

Line 114: ICX_CAT_PURCHASING_CAT_MAP_V ICXM

110: decode(POL.item_description, TLP.description,
111: decode(POL.item_id, TLP.inventory_item_id,
112: 'N', 'Y'), 'Y'), 'Y') -- Recreate Attribute TLP
113: FROM PO_LINES_ALL POL, PO_ATTRIBUTE_VALUES_TLP TLP,
114: ICX_CAT_PURCHASING_CAT_MAP_V ICXM
115: WHERE POL.last_updated_program = g_R12_MIGRATION_PROGRAM
116: AND POL.po_line_id = TLP.po_line_id
117: AND POL.CATEGORY_ID = ICXM.po_category_id(+)
118: AND TLP.language = p_base_lang

Line 381: ICX_CAT_PURCHASING_CAT_MAP_V ICXM

377: 'Y', -- Recreate Attrib Flag
378: 'Y' -- Recreate Attrib TLP Flag
379: FROM PO_LINES_ALL POL,
380: PO_HEADERS_ALL POH,
381: ICX_CAT_PURCHASING_CAT_MAP_V ICXM
382: WHERE POL.last_updated_program IS NULL
383: AND POL.po_header_id = POH.po_header_id
384: AND POH.type_lookup_code IN ('BLANKET', 'QUOTATION')
385: AND POL.CATEGORY_ID = ICXM.po_category_id(+)

Line 879: ICX_CAT_PURCHASING_CAT_MAP_V ICXM

875: DECODE(PORL.item_description, POATLP.description,
876: 'N', 'Y'), 'Y'), 'Y') -- Recreate Attribute TLP
877: FROM PO_REQEXPRESS_LINES_ALL PORL,
878: PO_ATTRIBUTE_VALUES_TLP POATLP,
879: ICX_CAT_PURCHASING_CAT_MAP_V ICXM
880: WHERE PORL.last_updated_program = g_R12_MIGRATION_PROGRAM
881: AND PORL.express_name = POATLP.req_template_name
882: AND PORL.sequence_num = POATLP.req_template_line_num
883: AND PORL.org_id = POATLP.org_id

Line 1143: ICX_CAT_PURCHASING_CAT_MAP_V ICXM

1139: NULL, -- Image
1140: NULL, -- ImageUrl
1141: NULL, 'Y','Y' -- Attribute, Recreate Attrib, Recreate Attrib TLP
1142: FROM PO_REQEXPRESS_LINES_ALL PORL,
1143: ICX_CAT_PURCHASING_CAT_MAP_V ICXM
1144: WHERE last_updated_program is null
1145: AND PORL.CATEGORY_ID = ICXM.po_category_id(+) ;
1146:
1147: l_api_name CONSTANT VARCHAR2(30) := 'process_new_rt_lines';