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_ATTRIBUTE_VALUES_TLP

Line 113: FROM PO_LINES_ALL POL, PO_ATTRIBUTE_VALUES_TLP TLP,

109: DECODE( NVL(icxm.shopping_category_id, NULL_ID), TLP.ip_category_id,
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(+)

Line 140: FROM PO_ATTRIBUTE_VALUES_TLP POATLP

136: AND MTL.language = MTL.source_lang
137: AND NOT EXISTS
138: (
139: SELECT 'Upgraded Lines with newly added item master translations'
140: FROM PO_ATTRIBUTE_VALUES_TLP POATLP
141: WHERE POATLP.po_line_id <> NULL_ID
142: AND POATLP.po_line_id = POL.po_line_id
143: AND POATLP.org_id = POL.org_id
144: AND POATLP.language = MTL.language

Line 287: DELETE FROM PO_ATTRIBUTE_VALUES_TLP POATLP

283: -- SQL Why : Instead of erasing the columns, just delete the rows from
284: -- attributes TLP table and recreate the row later.
285: -- SQL Join: po_line_id
286: FORALL i IN 1..gPoLineIds.COUNT
287: DELETE FROM PO_ATTRIBUTE_VALUES_TLP POATLP
288: WHERE po_line_id = gPoLineIds(i)
289: AND (gRecreateAttribTLPRow(i) = 'Y' OR gUpdatedAttribute(i) = 'LINE_DELETED');
290:
291:

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

288: WHERE po_line_id = gPoLineIds(i)
289: AND (gRecreateAttribTLPRow(i) = 'Y' OR gUpdatedAttribute(i) = 'LINE_DELETED');
290:
291:
292: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows deleted='||SQL%rowcount); END IF;
293:
294: l_progress := '120';
295: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Updating Attributes'); END IF;
296:

Line 297: -- SQL What: Update the PO attribute values TLP when the description has changed

293:
294: l_progress := '120';
295: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Updating Attributes'); END IF;
296:
297: -- SQL What: Update the PO attribute values TLP when the description has changed
298: -- SQL Why : Sync up the description at the TLP level
299: -- SQL Join: po_line_id
300: FORALL i IN 1..gPoLineIds.COUNT
301: UPDATE PO_ATTRIBUTE_VALUES_TLP

Line 301: UPDATE PO_ATTRIBUTE_VALUES_TLP

297: -- SQL What: Update the PO attribute values TLP when the description has changed
298: -- SQL Why : Sync up the description at the TLP level
299: -- SQL Join: po_line_id
300: FORALL i IN 1..gPoLineIds.COUNT
301: UPDATE PO_ATTRIBUTE_VALUES_TLP
302: SET description = gItemDescriptions(i),
303: last_updated_program = g_R12_MIGRATION_PROGRAM
304: WHERE po_line_id = gPoLineIds(i)
305: AND gUpdatedAttribute(i) = 'DESCRIPTION';

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

303: last_updated_program = g_R12_MIGRATION_PROGRAM
304: WHERE po_line_id = gPoLineIds(i)
305: AND gUpdatedAttribute(i) = 'DESCRIPTION';
306:
307: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows updated='||SQL%rowcount); END IF;
308:
309: l_progress := '130';
310:
311: -- Lines for which attributes records need to be created are in gPoLineIds

Line 634: INSERT INTO PO_ATTRIBUTE_VALUES_TLP

630: -- expense items you will still have this element, but the value
631: -- will be null.
632: -- SQL Join: several
633: FORALL i in 1..gInvItemIds.COUNT
634: INSERT INTO PO_ATTRIBUTE_VALUES_TLP
635: (
636: ATTRIBUTE_VALUES_TLP_ID,
637: PO_LINE_ID,
638: REQ_TEMPLATE_NAME,

Line 652: SELECT PO_ATTRIBUTE_VALUES_TLP_S.nextval,

648: LAST_UPDATE_DATE,
649: CREATED_BY,
650: CREATION_DATE
651: )
652: SELECT PO_ATTRIBUTE_VALUES_TLP_S.nextval,
653: gPoLineIds(i),
654: gPoReqTemplateNames(i), -- req_template_name
655: gPoReqTemplateLineIds(i), -- req_template_line_id
656: gIpCategoryIds(i), -- ip_category_id

Line 671: (SELECT /+ INDEX(POATLP, PO_ATTRIBUTE_VALUES_TLP_U2) /

667: FROM DUAL
668: WHERE gRecreateAttribTLPRow(i) = 'Y'
669: AND gInvItemIds(i) = NULL_ID -- Description based non catalog item
670: AND NOT EXISTS
671: (SELECT /*+ INDEX(POATLP, PO_ATTRIBUTE_VALUES_TLP_U2) */
672: NULL
673: FROM PO_ATTRIBUTE_VALUES_TLP POATLP
674: WHERE POATLP.po_line_id = gPoLineIds(i)
675: AND POATLP.req_template_name = gPoReqTemplateNames(i)

Line 673: FROM PO_ATTRIBUTE_VALUES_TLP POATLP

669: AND gInvItemIds(i) = NULL_ID -- Description based non catalog item
670: AND NOT EXISTS
671: (SELECT /*+ INDEX(POATLP, PO_ATTRIBUTE_VALUES_TLP_U2) */
672: NULL
673: FROM PO_ATTRIBUTE_VALUES_TLP POATLP
674: WHERE POATLP.po_line_id = gPoLineIds(i)
675: AND POATLP.req_template_name = gPoReqTemplateNames(i)
676: AND POATLP.req_template_line_num = to_char(gPoReqTemplateLineIds(i))
677: AND POATLP.org_id = gPoOrgIds(i));

Line 679: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows inserted by default='||SQL%rowcount); END IF;

675: AND POATLP.req_template_name = gPoReqTemplateNames(i)
676: AND POATLP.req_template_line_num = to_char(gPoReqTemplateLineIds(i))
677: AND POATLP.org_id = gPoOrgIds(i));
678:
679: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows inserted by default='||SQL%rowcount); END IF;
680:
681: l_progress := '030';
682: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Inserting for item master items (pulling translations from INV)'); END IF;
683:

Line 690: INSERT INTO PO_ATTRIBUTE_VALUES_TLP

686: -- SQL Why : Only those records that have gRecreateAttribTLPRow(i)='Y', need
687: -- to be created in the Attributes table.
688: -- SQL Join: several
689: FORALL i in 1..gPoLineIds.COUNT
690: INSERT INTO PO_ATTRIBUTE_VALUES_TLP
691: (
692: ATTRIBUTE_VALUES_TLP_ID,
693: PO_LINE_ID,
694: REQ_TEMPLATE_NAME,

Line 708: SELECT PO_ATTRIBUTE_VALUES_TLP_S.nextval,

704: LAST_UPDATE_DATE,
705: CREATED_BY,
706: CREATION_DATE
707: )
708: SELECT PO_ATTRIBUTE_VALUES_TLP_S.nextval,
709: gPoLineIds(i),
710: gPoReqTemplateNames(i), -- req_template_name
711: gPoReqTemplateLineIds(i), -- req_template_line_id
712: gIpCategoryIds(i), -- ip_category_id

Line 733: (SELECT /+ INDEX(POATLP, PO_ATTRIBUTE_VALUES_TLP_U2) /

729: AND gPoOrgIds(i) = FSP.org_id
730: AND FSP.inventory_organization_id = MTL.organization_id
731: AND MTL.language = MTL.source_lang
732: AND NOT EXISTS
733: (SELECT /*+ INDEX(POATLP, PO_ATTRIBUTE_VALUES_TLP_U2) */
734: NULL
735: FROM PO_ATTRIBUTE_VALUES_TLP POATLP
736: WHERE POATLP.language = MTL.language
737: AND POATLP.po_line_id = gPoLineIds(i)

Line 735: FROM PO_ATTRIBUTE_VALUES_TLP POATLP

731: AND MTL.language = MTL.source_lang
732: AND NOT EXISTS
733: (SELECT /*+ INDEX(POATLP, PO_ATTRIBUTE_VALUES_TLP_U2) */
734: NULL
735: FROM PO_ATTRIBUTE_VALUES_TLP POATLP
736: WHERE POATLP.language = MTL.language
737: AND POATLP.po_line_id = gPoLineIds(i)
738: AND POATLP.req_template_name = gPoReqTemplateNames(i)
739: AND POATLP.req_template_line_num = to_char(gPoReqTemplateLineIds(i))

Line 742: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows inserted due to item master translation='||SQL%rowcount); END IF;

738: AND POATLP.req_template_name = gPoReqTemplateNames(i)
739: AND POATLP.req_template_line_num = to_char(gPoReqTemplateLineIds(i))
740: AND POATLP.org_id = gPoOrgIds(i));
741:
742: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows inserted due to item master translation='||SQL%rowcount); END IF;
743:
744: l_progress := '040';
745: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Inserting for item master items that have no translation available in base lang'); END IF;
746:

Line 762: INSERT INTO PO_ATTRIBUTE_VALUES_TLP

758: -- 1. The created_lang is different from base_lang
759: -- 2. The MTL translation for created_lang does not exist
760: -- In this case, copy the description from the PO Line
761: FORALL i in 1..gPoLineIds.COUNT
762: INSERT INTO PO_ATTRIBUTE_VALUES_TLP
763: (
764: ATTRIBUTE_VALUES_TLP_ID,
765: PO_LINE_ID,
766: REQ_TEMPLATE_NAME,

Line 780: SELECT PO_ATTRIBUTE_VALUES_TLP_S.nextval,

776: LAST_UPDATE_DATE,
777: CREATED_BY,
778: CREATION_DATE
779: )
780: SELECT PO_ATTRIBUTE_VALUES_TLP_S.nextval,
781: gPoLineIds(i),
782: NULL_ID, --gPoReqTemplateNames(i), -- req_template_name
783: NULL_ID, --gPoReqTemplateLineIds(i), -- req_template_line_id
784: gIpCategoryIds(i), -- ip_category_id

Line 805: (SELECT /+ INDEX(POATLP, PO_ATTRIBUTE_VALUES_TLP_U2) /

801: AND POH.po_header_id = POL.po_header_id
802: --AND POH.created_language <> p_base_lang (ECO bug 4862164)
803: --AND POAT.po_line_id = POL.po_line_id -- make sure that the Attr row exists
804: AND NOT EXISTS
805: (SELECT /*+ INDEX(POATLP, PO_ATTRIBUTE_VALUES_TLP_U2) */
806: 'TLP row for created_lang already exists for Blanket/Quotation line'
807: FROM PO_ATTRIBUTE_VALUES_TLP POATLP
808: WHERE POATLP.language = POH.created_language
809: AND POATLP.po_line_id = gPoLineIds(i));

Line 807: FROM PO_ATTRIBUTE_VALUES_TLP POATLP

803: --AND POAT.po_line_id = POL.po_line_id -- make sure that the Attr row exists
804: AND NOT EXISTS
805: (SELECT /*+ INDEX(POATLP, PO_ATTRIBUTE_VALUES_TLP_U2) */
806: 'TLP row for created_lang already exists for Blanket/Quotation line'
807: FROM PO_ATTRIBUTE_VALUES_TLP POATLP
808: WHERE POATLP.language = POH.created_language
809: AND POATLP.po_line_id = gPoLineIds(i));
810:
811: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows inserted due to nonexistence of item master in created_lang ='||SQL%rowcount); END IF;

Line 811: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows inserted due to nonexistence of item master in created_lang ='||SQL%rowcount); END IF;

807: FROM PO_ATTRIBUTE_VALUES_TLP POATLP
808: WHERE POATLP.language = POH.created_language
809: AND POATLP.po_line_id = gPoLineIds(i));
810:
811: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows inserted due to nonexistence of item master in created_lang ='||SQL%rowcount); END IF;
812:
813: l_progress := '050';
814: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;
815: EXCEPTION

Line 878: PO_ATTRIBUTE_VALUES_TLP POATLP,

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
882: AND PORL.sequence_num = POATLP.req_template_line_num

Line 909: FROM PO_ATTRIBUTE_VALUES_TLP POATLP

905: AND MTL.language = MTL.source_lang
906: AND NOT EXISTS
907: (
908: SELECT 'Upgraded Lines with newly added item master translations'
909: FROM PO_ATTRIBUTE_VALUES_TLP POATLP
910: WHERE POATLP.req_template_name <> to_char(NULL_ID) -- Only look for Template records
911: AND PORL.express_name = POATLP.req_template_name
912: AND PORL.sequence_num = POATLP.req_template_line_num
913: AND PORL.org_id = POATLP.org_id

Line 1059: DELETE FROM PO_ATTRIBUTE_VALUES_TLP

1055: -- SQL Why : Instead of erasing the columns, just delete the rows from
1056: -- attributes TLP table and recreate the row later.
1057: -- SQL Join: express_name, sequence_num, org_id
1058: FORALL i IN 1..gPoLineIds.COUNT
1059: DELETE FROM PO_ATTRIBUTE_VALUES_TLP
1060: WHERE req_template_name = gPoReqTemplateNames(i)
1061: AND req_template_line_num = to_char(gPoReqTemplateLineIds(i))
1062: AND org_id = gPoOrgIds(i)
1063: AND (gRecreateAttribTLPRow(i) = 'Y' OR gUpdatedAttribute(i) = 'LINE_DELETED');

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

1061: AND req_template_line_num = to_char(gPoReqTemplateLineIds(i))
1062: AND org_id = gPoOrgIds(i)
1063: AND (gRecreateAttribTLPRow(i) = 'Y' OR gUpdatedAttribute(i) = 'LINE_DELETED');
1064:
1065: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows deleted='||SQL%rowcount); END IF;
1066:
1067: l_progress := '120';
1068:
1069: -- SQL What: Update the PO attribute values TLP when the description has

Line 1069: -- SQL What: Update the PO attribute values TLP when the description has

1065: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows deleted='||SQL%rowcount); END IF;
1066:
1067: l_progress := '120';
1068:
1069: -- SQL What: Update the PO attribute values TLP when the description has
1070: -- changed.
1071: -- SQL Why : Sync up the description
1072: -- SQL Join: express_name, sequence_num, org_id
1073: FORALL i in 1..gPoLineIds.COUNT

Line 1074: UPDATE PO_ATTRIBUTE_VALUES_TLP

1070: -- changed.
1071: -- SQL Why : Sync up the description
1072: -- SQL Join: express_name, sequence_num, org_id
1073: FORALL i in 1..gPoLineIds.COUNT
1074: UPDATE PO_ATTRIBUTE_VALUES_TLP
1075: SET description = gItemDescriptions(i),
1076: last_updated_program = g_R12_MIGRATION_PROGRAM
1077: WHERE req_template_name = gPoReqTemplateNames(i)
1078: AND req_template_line_num = to_char(gPoReqTemplateLineIds(i))

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

1078: AND req_template_line_num = to_char(gPoReqTemplateLineIds(i))
1079: AND org_id = gPoOrgIds(i)
1080: AND gUpdatedAttribute(i) = 'DESCRIPTION';
1081:
1082: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of PO_ATTRIBUTE_VALUES_TLP rows updated='||SQL%rowcount); END IF;
1083:
1084: l_progress := '130';
1085:
1086: -- Lines for which attributes records need to be created are in