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_POR_EXT_ITEM dependencies on ICX_POR_EXT_TEST

Line 1535: xTestMode := ICX_POR_EXT_TEST.gTestMode;

1531: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL THEN
1532: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
1533: 'Enter setActivePriceItemAttributes()');
1534: END IF;
1535: xTestMode := ICX_POR_EXT_TEST.gTestMode;
1536: xErrLoc := 100;
1537: xString :=
1538: 'SELECT p.rt_item_id, t.item_description, ' ||
1539: ' null, null ' ;

Line 3709: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

3705: xString :=
3706: 'SELECT m.description, ' ||
3707: 'm.language, ' ||
3708: 'ctl.category_name ';
3709: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
3710: xString := xString ||
3711: 'FROM imtl_system_items_tl m, ';
3712: ELSE
3713: xString := xString ||

Line 3871: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

3867: 'SELECT m.description, ' ||
3868: 'm.language, ' ||
3869: 'ctl.category_name, ' ||
3870: 't.rt_item_id ';
3871: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
3872: xString := xString ||
3873: 'FROM imtl_system_items_tl m, ';
3874: ELSE
3875: xString := xString ||

Line 4083: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

4079: -- Docuements with inventory Items
4080: xErrLoc := 150;
4081: xString :=
4082: 'SELECT m.language ';
4083: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
4084: xString := xString ||
4085: 'FROM imtl_system_items_tl m ';
4086: ELSE
4087: xString := xString ||

Line 4192: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

4188: xErrLoc := 150;
4189: xString :=
4190: 'SELECT m.language, ' ||
4191: 't.rt_item_id ';
4192: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
4193: xString := xString ||
4194: 'FROM imtl_system_items_tl m, ';
4195: ELSE
4196: xString := xString ||

Line 5726: 'prl.po_line_id, '''||ICX_POR_EXT_TEST.gTestMode||''') status ';

5722: 'prl.suggested_buyer_id buyer_id, '||
5723: 'TO_CHAR(NULL) global_agreement_flag, '||
5724: 'ICX_POR_EXT_DIAG.getTemplateLineStatus(prl.express_name, '||
5725: 'prl.sequence_num, prl.org_id, prh.inactive_date, '||
5726: 'prl.po_line_id, '''||ICX_POR_EXT_TEST.gTestMode||''') status ';
5727: xViewStr2 :=
5728: 'FROM icx_por_loader_values l, ';
5729: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
5730: xViewStr2 := xViewStr2 ||

Line 5729: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

5725: 'prl.sequence_num, prl.org_id, prh.inactive_date, '||
5726: 'prl.po_line_id, '''||ICX_POR_EXT_TEST.gTestMode||''') status ';
5727: xViewStr2 :=
5728: 'FROM icx_por_loader_values l, ';
5729: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
5730: xViewStr2 := xViewStr2 ||
5731: 'ipo_reqexpress_headers_all prh, '||
5732: 'ipo_reqexpress_lines_all prl, '||
5733: 'ipo_headers_all ph, '||

Line 5961: ICX_POR_EXT_TEST.gTestMode||''') status ';

5957: 'pl.line_type_id, '||
5958: 'ph.agent_id buyer_id, '||
5959: 'ph.global_agreement_flag, '||
5960: 'ICX_POR_EXT_DIAG.getContractLineStatus(pl.po_line_id, '''||
5961: ICX_POR_EXT_TEST.gTestMode||''') status ';
5962: xViewStr2 :=
5963: 'FROM icx_por_loader_values l, ';
5964: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
5965: xViewStr2 := xViewStr2 ||

Line 5964: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

5960: 'ICX_POR_EXT_DIAG.getContractLineStatus(pl.po_line_id, '''||
5961: ICX_POR_EXT_TEST.gTestMode||''') status ';
5962: xViewStr2 :=
5963: 'FROM icx_por_loader_values l, ';
5964: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
5965: xViewStr2 := xViewStr2 ||
5966: 'ipo_headers_all ph, '||
5967: 'ipo_lines_all pl, '||
5968: 'imtl_system_items_kfv mi, '||

Line 6041: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

6037: 'pl.expiration_date BETWEEN l.contracts_last_run_date AND '||
6038: 'SYSDATE OR '||
6039: '(ph.type_lookup_code = ''QUOTATION'' AND '||
6040: 'EXISTS (SELECT ''updated quotaion line location'' ';
6041: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
6042: xViewStr2 := xViewStr2 ||
6043: 'FROM ipo_line_locations_all pll, '||
6044: 'ipo_quotation_approvals_all pqa ';
6045: ELSE

Line 6161: 'mi.list_price_per_unit, '''||ICX_POR_EXT_TEST.gTestMode||

6157: 'TO_NUMBER(NULL) buyer_id, '||
6158: 'TO_CHAR(NULL) global_agreement_flag, '||
6159: 'ICX_POR_EXT_DIAG.getASLStatus(pasl.asl_id, '||
6160: 'pasl.disable_flag, pasl.asl_status_id, '||
6161: 'mi.list_price_per_unit, '''||ICX_POR_EXT_TEST.gTestMode||
6162: ''') status ';
6163: xViewStr2 :=
6164: 'FROM icx_por_loader_values l, ';
6165: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

Line 6165: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

6161: 'mi.list_price_per_unit, '''||ICX_POR_EXT_TEST.gTestMode||
6162: ''') status ';
6163: xViewStr2 :=
6164: 'FROM icx_por_loader_values l, ';
6165: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
6166: xViewStr2 := xViewStr2 ||
6167: 'ipo_approved_supplier_list pasl, '||
6168: 'imtl_system_items_kfv mi, '||
6169: 'imtl_system_items_tl mitl, '||

Line 6275: 'mi.list_price_per_unit, '''||ICX_POR_EXT_TEST.gTestMode||'''), '||

6271: 'TO_CHAR(NULL) global_agreement_flag, '||
6272: 'DECODE(type.document_type, '||PURCHASING_ITEM_TYPE||', '||
6273: 'ICX_POR_EXT_DIAG.getPurchasingItemStatus(mi.purchasing_enabled_flag, '||
6274: 'mi.outside_operation_flag, '||
6275: 'mi.list_price_per_unit, '''||ICX_POR_EXT_TEST.gTestMode||'''), '||
6276: 'ICX_POR_EXT_DIAG.getInternalItemStatus(mi.internal_order_enabled_flag, '''||
6277: ICX_POR_EXT_TEST.gTestMode||''')) status ';
6278: xViewStr2 :=
6279: 'FROM icx_por_loader_values l, ';

Line 6277: ICX_POR_EXT_TEST.gTestMode||''')) status ';

6273: 'ICX_POR_EXT_DIAG.getPurchasingItemStatus(mi.purchasing_enabled_flag, '||
6274: 'mi.outside_operation_flag, '||
6275: 'mi.list_price_per_unit, '''||ICX_POR_EXT_TEST.gTestMode||'''), '||
6276: 'ICX_POR_EXT_DIAG.getInternalItemStatus(mi.internal_order_enabled_flag, '''||
6277: ICX_POR_EXT_TEST.gTestMode||''')) status ';
6278: xViewStr2 :=
6279: 'FROM icx_por_loader_values l, ';
6280: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
6281: xViewStr2 := xViewStr2 ||

Line 6280: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

6276: 'ICX_POR_EXT_DIAG.getInternalItemStatus(mi.internal_order_enabled_flag, '''||
6277: ICX_POR_EXT_TEST.gTestMode||''')) status ';
6278: xViewStr2 :=
6279: 'FROM icx_por_loader_values l, ';
6280: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
6281: xViewStr2 := xViewStr2 ||
6282: 'imtl_system_items_kfv mi, '||
6283: 'imtl_categories_kfv mc, '||
6284: 'imtl_item_categories mic, '||

Line 6317: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

6313: -- Bug # 3529303
6314: 'mi.last_update_date > LEAST(nvl(l.item_master_last_run_date, '||
6315: 'sysdate), nvl(l.internal_item_last_run_date, sysdate)) OR '||
6316: 'EXISTS (SELECT ''updated description'' ';
6317: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
6318: xViewStr2 := xViewStr2 ||
6319: 'FROM imtl_system_items_tl mitl ';
6320: ELSE
6321: xViewStr2 := xViewStr2 ||

Line 6556: ICX_POR_EXT_TEST.gTestMode||''') status, '||

6552: 'mi2.purchasing_enabled_flag, '||
6553: 'mi2.outside_operation_flag, '||
6554: 'ip.unit_of_measure, '||
6555: 'mi2.primary_uom_code, '''||
6556: ICX_POR_EXT_TEST.gTestMode||''') status, '||
6557: 'ip.rt_item_id price_rt_item_id ';
6558:
6559: xErrLoc := 620;
6560: xViewStr2 :=

Line 6562: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

6558:
6559: xErrLoc := 620;
6560: xViewStr2 :=
6561: 'FROM icx_por_loader_values l, ';
6562: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
6563: xViewStr2 := xViewStr2 ||
6564: 'ipo_ga_org_assignments t, '||
6565: 'ipo_vendor_sites_all pvs, '||
6566: 'imtl_system_items_kfv mi, '||

Line 6796: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

6792: xErrLoc := 120;
6793: xString :=
6794: 'SELECT /*+ LEADING(v) */ v.vendor_id, '||
6795: 'v.vendor_name ';
6796: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
6797: xString := xString ||
6798: 'FROM ipo_vendors v, ';
6799: ELSE
6800: xString := xString ||

Line 6938: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

6934: xString :=
6935: 'SELECT /*+ LEADING(vs) */ ' ||
6936: ' vs.vendor_site_id, ' ||
6937: ' vs.vendor_site_code ';
6938: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
6939: xString := xString ||
6940: 'FROM ipo_vendor_sites_all vs, ';
6941: ELSE
6942: xString := xString ||

Line 7403: ICX_POR_EXT_TEST.gTestMode||''') <> '||

7399: 'WHERE p.price_type IN (''TEMPLATE'', ''INTERNAL_TEMPLATE'', ' ||
7400: ' ''BLANKET'', ''QUOTATION'', ''GLOBAL_AGREEMENT'', ''ASL'', ' ||
7401: ' ''PURCHASING_ITEM'', ''INTERNAL_ITEM'') ' ||
7402: 'AND ICX_POR_EXT_DIAG.getPriceStatus(p.price_type, p.rowid, '''||
7403: ICX_POR_EXT_TEST.gTestMode||''') <> '||
7404: ICX_POR_EXT_DIAG.VALID_FOR_EXTRACT||' '||
7405: 'AND p.template_id||''_tmpl'' = ic.key (+) '||
7406: 'AND ic.type (+) = '||ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE||' '||
7407: 'AND ic.language (+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' ';

Line 7408: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN

7404: ICX_POR_EXT_DIAG.VALID_FOR_EXTRACT||' '||
7405: 'AND p.template_id||''_tmpl'' = ic.key (+) '||
7406: 'AND ic.type (+) = '||ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE||' '||
7407: 'AND ic.language (+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' ';
7408: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
7409: xString := xString ||
7410: 'AND p.last_updated_by = '||ICX_POR_EXT_TEST.TEST_USER_ID||' ';
7411: END IF;
7412:

Line 7410: 'AND p.last_updated_by = '||ICX_POR_EXT_TEST.TEST_USER_ID||' ';

7406: 'AND ic.type (+) = '||ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE||' '||
7407: 'AND ic.language (+) = '''||ICX_POR_EXTRACTOR.gBaseLang||''' ';
7408: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
7409: xString := xString ||
7410: 'AND p.last_updated_by = '||ICX_POR_EXT_TEST.TEST_USER_ID||' ';
7411: END IF;
7412:
7413: xErrLoc := 160;
7414: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.INFO_LEVEL THEN