APPS.ICX_POR_EXT_DIAG dependencies on ICX_CAT_ITEM_PRICES

Line 1868: l_express_name ICX_CAT_ITEM_PRICES.TEMPLATE_ID%TYPE;

1864: l_internal_order_enabled VARCHAR2(1);
1865:
1866: -- Bug#3464695
1867: l_asl_id NUMBER;
1868: l_express_name ICX_CAT_ITEM_PRICES.TEMPLATE_ID%TYPE;
1869: l_sequence_num NUMBER;
1870: l_rt_org_id NUMBER;
1871:
1872: BEGIN

Line 1880: 'FROM icx_cat_item_prices p, ';

1876: 'prl.sequence_num, '||
1877: 'prl.org_id, '||
1878: 'prh.inactive_date, '||
1879: 'p.contract_line_id '||
1880: 'FROM icx_cat_item_prices p, ';
1881: IF p_test_mode = 'Y' THEN
1882: xString := xString ||
1883: 'ipo_reqexpress_headers_all prh, '||
1884: 'ipo_reqexpress_lines_all prl ';

Line 1914: FROM icx_cat_item_prices

1910:
1911: ELSIF p_price_type IN ('BLANKET', 'QUOTATION') THEN
1912: SELECT contract_line_id
1913: INTO l_contract_line_id
1914: FROM icx_cat_item_prices
1915: WHERE rowid = p_row_id;
1916: xStatus := getContractLineStatus(l_contract_line_id,
1917: p_test_mode);
1918: ELSIF p_price_type = 'GLOBAL_AGREEMENT' THEN

Line 1930: 'FROM icx_cat_item_prices p, ';

1926: 'mi.primary_uom_code, '||
1927: 'mi2.purchasing_enabled_flag, '||
1928: 'mi2.outside_operation_flag, '||
1929: 'mi2.primary_uom_code '||
1930: 'FROM icx_cat_item_prices p, ';
1931: IF p_test_mode = 'Y' THEN
1932: xString := xString ||
1933: 'ipo_ga_org_assignments t, '||
1934: 'ipo_vendor_sites_all pvs, '||

Line 1990: 'FROM icx_cat_item_prices p, ';

1986: 'SELECT pasl.asl_id, '||
1987: 'pasl.disable_flag, '||
1988: 'pasl.asl_status_id, '||
1989: 'mi.list_price_per_unit '||
1990: 'FROM icx_cat_item_prices p, ';
1991: IF p_test_mode = 'Y' THEN
1992: xString := xString ||
1993: 'ipo_approved_supplier_list pasl, '||
1994: 'imtl_system_items_kfv mi, '||

Line 2025: 'FROM icx_cat_item_prices p, ';

2021: xString :=
2022: 'SELECT mi.purchasing_enabled_flag, '||
2023: 'mi.outside_operation_flag, '||
2024: 'mi.list_price_per_unit '||
2025: 'FROM icx_cat_item_prices p, ';
2026: IF p_test_mode = 'Y' THEN
2027: xString := xString ||
2028: 'imtl_system_items_kfv mi, '||
2029: 'ifinancials_system_params_all fsp ';

Line 2052: 'FROM icx_cat_item_prices p, ';

2048: p_test_mode);
2049: ELSIF p_price_type = 'INTERNAL_ITEM' THEN
2050: xString :=
2051: 'SELECT mi.internal_order_enabled_flag '||
2052: 'FROM icx_cat_item_prices p, ';
2053: IF p_test_mode = 'Y' THEN
2054: xString := xString ||
2055: 'imtl_system_items_kfv mi, '||
2056: 'ifinancials_system_params_all fsp ';