eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_R12_CAT_UPG_EXISTING_DOCS dependencies on PO_REQEXPRESS_LINES_ALL

Line 877: FROM PO_REQEXPRESS_LINES_ALL PORL,

873: NVL(ICXM.shopping_category_id, NULL_ID), POATLP.ip_category_id,
874: DECODE(PORL.item_id, POATLP.inventory_item_id,
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

Line 897: FROM PO_REQEXPRESS_LINES_ALL PORL,

893: NVL(PORL.item_id, NULL_ID), PORL.org_id, PORL.item_description,
894: NULL, -- Image
895: NULL, -- ImageUrl
896: 'ITEM_TRANSLATION', 'N','Y' -- Attribute, Recreate Attrib, Recreate Attrib TLP
897: FROM PO_REQEXPRESS_LINES_ALL PORL,
898: MTL_SYSTEM_ITEMS_TL MTL,
899: FINANCIALS_SYSTEM_PARAMS_ALL FSP
900: WHERE PORL.last_updated_program = g_R12_MIGRATION_PROGRAM
901: AND item_id IS NOT NULL

Line 931: FROM PO_REQEXPRESS_LINES_ALL PORL

927: -- Req Template lines that have been deleted but have attribute reference
928: -- (Need to be purged)
929: (
930: SELECT 'Req Template lines deleted'
931: FROM PO_REQEXPRESS_LINES_ALL PORL
932: WHERE PORL.express_name = POAT.req_template_name
933: AND PORL.sequence_num = POAT.req_template_line_num
934: AND PORL.org_id = POAT.org_id
935: );

Line 955: FROM PO_REQEXPRESS_LINES_ALL PORL

951: -- for those lines that have been modified since the last upgrade.
952: -- SQL Join: last_updated_program
953: SELECT count(*)
954: INTO l_was_R12_upg_ever_run_before
955: FROM PO_REQEXPRESS_LINES_ALL PORL
956: WHERE PORL.last_updated_program = g_R12_MIGRATION_PROGRAM
957: AND rownum=1;
958:
959: l_progress := '030';

Line 1018: -- SQL What: Update the PO_REQEXPRESS_LINES_ALL with ip_category_id

1014: EXIT WHEN gPoReqTemplateLineIds.COUNT = 0;
1015:
1016: l_progress := '090';
1017:
1018: -- SQL What: Update the PO_REQEXPRESS_LINES_ALL with ip_category_id
1019: -- SQL Why : Part of catalog upgrade requirements
1020: -- SQL Join: express_name, sequence_num, org_id
1021: -- We are specifically not updating the last_updated_by, login columns
1022: -- because we want to preserve that information(updating -2 to these

Line 1026: UPDATE PO_REQEXPRESS_LINES_ALL PORL

1022: -- because we want to preserve that information(updating -2 to these
1023: -- columns is not useful when we already have the
1024: -- last_updated_program updated to g_R12_MIGRATION_PROGRAM
1025: FORALL i IN 1..gPoReqTemplateLineIds.COUNT
1026: UPDATE PO_REQEXPRESS_LINES_ALL PORL
1027: SET ip_category_id = gIpCategoryIds(i),
1028: last_updated_program = g_R12_MIGRATION_PROGRAM
1029: WHERE PORL.express_name = gPoReqTemplateNames(i)
1030: AND PORL.sequence_num = to_char(gPoReqTemplateLineIds(i))

Line 1034: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_REQEXPRESS_LINES_ALL rows updated='||SQL%rowcount); END IF;

1030: AND PORL.sequence_num = to_char(gPoReqTemplateLineIds(i))
1031: AND PORL.org_id = gPoOrgIds(i)
1032: AND gUpdatedAttribute(i) = 'IP_CATEGORY_ID';
1033:
1034: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_REQEXPRESS_LINES_ALL rows updated='||SQL%rowcount); END IF;
1035:
1036: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Deleting Attributes:Template'); END IF;
1037:
1038: l_progress := '100';

Line 1142: FROM PO_REQEXPRESS_LINES_ALL PORL,

1138: NVL(PORL.item_id, NULL_ID), PORL.org_id, PORL.item_description,
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:

Line 1208: -- SQL What: Update the PO_REQEXPRESS_LINES_ALL with ip_category_id

1204: EXIT WHEN gPoReqTemplateLineIds.COUNT = 0;
1205:
1206: l_progress := '080';
1207:
1208: -- SQL What: Update the PO_REQEXPRESS_LINES_ALL with ip_category_id
1209: -- SQL Why : Part of catalog upgrade requirements
1210: -- SQL Join: express_name, sequence_num, org_id
1211: -- We are specifically not updating the last_updated_by, login columns
1212: -- because we want to preserve that information(updating -2 to these

Line 1216: UPDATE PO_REQEXPRESS_LINES_ALL PORL

1212: -- because we want to preserve that information(updating -2 to these
1213: -- columns is not useful when we already have the
1214: -- last_updated_program updated to g_R12_MIGRATION_PROGRAM
1215: FORALL i IN 1..gPoReqTemplateLineIds.COUNT
1216: UPDATE PO_REQEXPRESS_LINES_ALL PORL
1217: SET ip_category_id = gIpCategoryIds(i),
1218: last_updated_program = g_R12_MIGRATION_PROGRAM
1219: WHERE express_name = gPoReqTemplateNames(i)
1220: AND sequence_num = to_char(gPoReqTemplateLineIds(i))

Line 1223: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_REQEXPRESS_LINES_ALL rows updated='||SQL%rowcount); END IF;

1219: WHERE express_name = gPoReqTemplateNames(i)
1220: AND sequence_num = to_char(gPoReqTemplateLineIds(i))
1221: AND org_id = gPoOrgIds(i);
1222:
1223: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_REQEXPRESS_LINES_ALL rows updated='||SQL%rowcount); END IF;
1224:
1225: l_progress := '090';
1226:
1227: -- Lines for which attributes need to be created are in gPoLineIds