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.ICX_CAT_POPULATE_PODOCS_PVT dependencies on ICX_CAT_ITEMS_CTX_HDRS_TLP

Line 145: icx_cat_items_ctx_hdrs_tlp ctx

141: AND po_tlp.language = ic.language (+)
142: AND ph.vendor_id = pv.vendor_id(+)
143: AND pl.po_line_id >= p_po_line_id
144: ) doc,
145: icx_cat_items_ctx_hdrs_tlp ctx
146: WHERE doc.po_line_id = ctx.po_line_id (+)
147: AND doc.org_id = ctx.org_id (+)
148: AND doc.source_type = ctx.source_type (+)
149: AND doc.language = ctx.language (+)

Line 278: icx_cat_items_ctx_hdrs_tlp ctx

274: AND po_tlp.language = ic.language (+)
275: AND ph.vendor_id = pv.vendor_id(+)
276: AND pl.po_line_id >= p_po_line_id
277: ) doc,
278: icx_cat_items_ctx_hdrs_tlp ctx
279: WHERE doc.po_line_id = ctx.po_line_id (+)
280: AND doc.org_id = ctx.org_id (+)
281: AND doc.source_type = ctx.source_type (+)
282: AND doc.language = ctx.language (+)

Line 741: SELECT /+ LEADING(doc) use_nl(ctx) index(ctxIn, ICX_CAT_ITEMS_CTX_HDRS_TLP_PK) /

737: --Open the GBPA cursor now
738: IF (g_upgrade_last_run_date) IS NULL THEN
739: l_err_loc := 300;
740: OPEN l_gbpa_csr FOR
741: SELECT /*+ LEADING(doc) use_nl(ctx) index(ctxIn, ICX_CAT_ITEMS_CTX_HDRS_TLP_PK) */
742: doc.*,
743: ctx.inventory_item_id ctx_inventory_item_id,
744: ctx.source_type ctx_source_type,
745: ctx.item_type ctx_item_type,

Line 758: index(ctxIn,ICX_CAT_ITEMS_CTX_HDRS_TLP_PK) NO_MERGE */

754: ROWIDTOCHAR(ctx.rowid) ctx_rowid
755: FROM
756: (
757: SELECT /*+ ROWID(ph) leading(ph,pv,t,pl,pltb,ctxIn) use_nl(pl,ctxIn,t) index(t,PO_GA_ORG_ASSIGN_U1)
758: index(ctxIn,ICX_CAT_ITEMS_CTX_HDRS_TLP_PK) NO_MERGE */
759: NVL(pl.item_id, -2) inventory_item_id,
760: pl.po_line_id po_line_id,
761: NVL(t.organization_id, -2) org_id,
762: ctxIn.language language,

Line 798: icx_cat_items_ctx_hdrs_tlp ctxIn,

794: NVL(t.enabled_flag, 'N') enabled_flag
795: FROM po_ga_org_assignments t,
796: po_headers_all ph,
797: po_lines_all pl,
798: icx_cat_items_ctx_hdrs_tlp ctxIn,
799: po_vendors pv,
800: po_line_types_b pltb
801: WHERE ph.global_agreement_flag = 'Y'
802: AND ph.po_header_id = t.po_header_id

Line 811: icx_cat_items_ctx_hdrs_tlp ctx

807: AND pl.line_type_id = pltb.line_type_id
808: AND ph.vendor_id = pv.vendor_id(+)
809: AND ph.rowid BETWEEN g_start_rowid AND g_end_rowid
810: ) doc,
811: icx_cat_items_ctx_hdrs_tlp ctx
812: WHERE doc.po_line_id = ctx.po_line_id (+)
813: AND doc.org_id = ctx.org_id (+)
814: AND doc.source_type = ctx.source_type (+)
815: AND doc.language = ctx.language (+);

Line 819: SELECT /+ LEADING(doc) use_nl(ctx) index(ctxIn, ICX_CAT_ITEMS_CTX_HDRS_TLP_PK) /

815: AND doc.language = ctx.language (+);
816: ELSE
817: l_err_loc := 400;
818: OPEN l_gbpa_csr FOR
819: SELECT /*+ LEADING(doc) use_nl(ctx) index(ctxIn, ICX_CAT_ITEMS_CTX_HDRS_TLP_PK) */
820: doc.*,
821: ctx.inventory_item_id ctx_inventory_item_id,
822: ctx.source_type ctx_source_type,
823: ctx.item_type ctx_item_type,

Line 836: index(ctxIn,ICX_CAT_ITEMS_CTX_HDRS_TLP_PK) NO_MERGE */

832: ROWIDTOCHAR(ctx.rowid) ctx_rowid
833: FROM
834: (
835: SELECT /*+ ROWID(ph) leading(ph,pv,t,pl,pltb,ctxIn) use_nl(pl,ctxIn,t) index(t,PO_GA_ORG_ASSIGN_U1)
836: index(ctxIn,ICX_CAT_ITEMS_CTX_HDRS_TLP_PK) NO_MERGE */
837: NVL(pl.item_id, -2) inventory_item_id,
838: pl.po_line_id po_line_id,
839: NVL(t.organization_id, -2) org_id,
840: ctxIn.language language,

Line 876: icx_cat_items_ctx_hdrs_tlp ctxIn,

872: NVL(t.enabled_flag, 'N') enabled_flag
873: FROM po_ga_org_assignments t,
874: po_headers_all ph,
875: po_lines_all pl,
876: icx_cat_items_ctx_hdrs_tlp ctxIn,
877: po_vendors pv,
878: po_line_types_b pltb
879: WHERE ph.global_agreement_flag = 'Y'
880: AND ph.po_header_id = t.po_header_id

Line 892: icx_cat_items_ctx_hdrs_tlp ctx

888: AND (ph.last_update_date > g_upgrade_last_run_date
889: OR pl.last_update_date > g_upgrade_last_run_date
890: OR t.last_update_date > g_upgrade_last_run_date)
891: ) doc,
892: icx_cat_items_ctx_hdrs_tlp ctx
893: WHERE doc.po_line_id = ctx.po_line_id (+)
894: AND doc.org_id = ctx.org_id (+)
895: AND doc.source_type = ctx.source_type (+)
896: AND doc.language = ctx.language (+);

Line 995: icx_cat_items_ctx_hdrs_tlp ctxIn,

991: FROM po_ga_org_assignments t,
992: po_headers_all ph,
993: po_lines_all pl,
994: po_session_gt pogt,
995: icx_cat_items_ctx_hdrs_tlp ctxIn,
996: po_vendors pv,
997: po_line_types_b pltb
998: WHERE ph.global_agreement_flag = 'Y'
999: AND ph.po_header_id = t.po_header_id

Line 1014: icx_cat_items_ctx_hdrs_tlp ctx

1010: AND pl.line_type_id = pltb.line_type_id
1011: AND ph.vendor_id = pv.vendor_id(+)
1012: AND pl.po_line_id >= p_po_line_id
1013: ) doc,
1014: icx_cat_items_ctx_hdrs_tlp ctx
1015: WHERE doc.po_line_id = ctx.po_line_id (+)
1016: AND doc.org_id = ctx.org_id (+)
1017: AND doc.source_type = ctx.source_type (+)
1018: AND doc.language = ctx.language (+)

Line 1117: icx_cat_items_ctx_hdrs_tlp ctxIn,

1113: FROM po_ga_org_assignments t,
1114: po_headers_all ph,
1115: po_lines_all pl,
1116: po_session_gt pogt,
1117: icx_cat_items_ctx_hdrs_tlp ctxIn,
1118: po_vendors pv,
1119: po_line_types_b pltb
1120: WHERE ph.global_agreement_flag = 'Y'
1121: AND ph.po_header_id = t.po_header_id

Line 1133: icx_cat_items_ctx_hdrs_tlp ctx

1129: ANd pl.line_type_id = pltb.line_type_id
1130: AND ph.vendor_id = pv.vendor_id(+)
1131: AND pl.po_line_id >= p_po_line_id
1132: ) doc,
1133: icx_cat_items_ctx_hdrs_tlp ctx
1134: WHERE doc.po_line_id = ctx.po_line_id (+)
1135: AND doc.org_id = ctx.org_id (+)
1136: AND doc.source_type = ctx.source_type (+)
1137: AND doc.language = ctx.language (+)

Line 1639: SELECT /+ LEADING(doc) use_nl_with_index(ctx,ICX_CAT_ITEMS_CTX_HDRS_TLP_PK) NO_EXPAND /

1635: -- to eliminate the TEMP LABOR line
1636: IF (g_upgrade_last_run_date) IS NULL THEN
1637: l_err_loc := 400;
1638: OPEN l_bpa_quote_csr FOR
1639: SELECT /*+ LEADING(doc) use_nl_with_index(ctx,ICX_CAT_ITEMS_CTX_HDRS_TLP_PK) NO_EXPAND */
1640: doc.*,
1641: ctx.inventory_item_id ctx_inventory_item_id,
1642: ctx.source_type ctx_source_type,
1643: ctx.item_type ctx_item_type,

Line 1729: icx_cat_items_ctx_hdrs_tlp ctx

1725: AND po_tlp.language = ic.language (+)
1726: AND ph.vendor_id = pv.vendor_id(+)
1727: AND ph.rowid BETWEEN g_start_rowid AND g_end_rowid
1728: ) doc,
1729: icx_cat_items_ctx_hdrs_tlp ctx
1730: WHERE doc.po_line_id = ctx.po_line_id (+)
1731: AND doc.org_id = ctx.org_id (+)
1732: AND doc.source_type = ctx.source_type (+)
1733: AND doc.language = ctx.language (+)

Line 1739: SELECT /+ LEADING(doc) use_nl_with_index(ctx,ICX_CAT_ITEMS_CTX_HDRS_TLP_PK) NO_EXPAND /

1735: OR (ctx.rowid IS NOT NULL OR doc.quote_status = 0));
1736: ELSE
1737: l_err_loc := 500;
1738: OPEN l_bpa_quote_csr FOR
1739: SELECT /*+ LEADING(doc) use_nl_with_index(ctx,ICX_CAT_ITEMS_CTX_HDRS_TLP_PK) NO_EXPAND */
1740: doc.*,
1741: ctx.inventory_item_id ctx_inventory_item_id,
1742: ctx.source_type ctx_source_type,
1743: ctx.item_type ctx_item_type,

Line 1833: icx_cat_items_ctx_hdrs_tlp ctx

1829: OR pl.last_update_date > g_upgrade_last_run_date
1830: OR ga.last_update_date > g_upgrade_last_run_date
1831: OR po_tlp.last_update_date > g_upgrade_last_run_date)
1832: ) doc,
1833: icx_cat_items_ctx_hdrs_tlp ctx
1834: WHERE doc.po_line_id = ctx.po_line_id (+)
1835: AND doc.org_id = ctx.org_id (+)
1836: AND doc.source_type = ctx.source_type (+)
1837: AND doc.language = ctx.language (+)

Line 2380: icx_cat_items_ctx_hdrs_tlp ctx

2376: AND po_tlp.language = ic.language (+)
2377: AND ph.vendor_id = pv.vendor_id(+)
2378: AND pl.po_line_id >= p_po_line_id
2379: ) doc,
2380: icx_cat_items_ctx_hdrs_tlp ctx
2381: WHERE doc.po_line_id = ctx.po_line_id (+)
2382: AND doc.org_id = ctx.org_id (+)
2383: AND doc.source_type = ctx.source_type (+)
2384: AND doc.language = ctx.language (+)