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_ITEM_UPLOAD dependencies on ICX_CAT_ITEM_PRICES

Line 788: INSERT into icx_cat_item_prices(rt_item_id, price_type, supplier_site_id, org_id,

784: ELSE
785:
786: xErrLoc := 150;
787: FORALL i IN 1..gRowids.COUNT
788: INSERT into icx_cat_item_prices(rt_item_id, price_type, supplier_site_id, org_id,
789: active_flag, search_type, unit_price, currency, unit_of_measure,
790: supplier_site_code, price_list_id, request_id, created_by, creation_date,
791: last_updated_by, last_update_login, last_update_date, object_version_number, contract_num, contract_id,
792: negotiated_by_preparer_flag) --Bug#3107596

Line 888: FROM icx_cat_item_prices

884: active_flag, search_type, unit_price, currency, unit_of_measure, functional_price,
885: supplier_site_code, contract_num, contract_line_num, price_list_id, sysdate,
886: last_update_login, last_updated_by, last_update_date, created_by, creation_date,
887: request_id, program_application_id, program_id, program_update_date,object_version_number
888: FROM icx_cat_item_prices
889: WHERE rt_item_id = gItemIds(i)
890: AND price_list_id = gPricelistIds(i)
891: AND org_id = gOrgIds(i)
892: AND supplier_site_id = gSupplierSiteIds(i)

Line 924: INSERT into icx_cat_item_prices(rt_item_id, price_type, supplier_site_id, org_id,

920:
921: IF (p_batch_type = 'PRICE') THEN
922: -- insert the new prices
923: FORALL i in 1..gRowIds.COUNT
924: INSERT into icx_cat_item_prices(rt_item_id, price_type, supplier_site_id, org_id,
925: active_flag, search_type, unit_price, currency, unit_of_measure,
926: supplier_site_code, price_list_id, request_id, created_by, creation_date,
927: last_updated_by, last_update_login, last_update_date, contract_num, contract_id, object_version_number,
928: negotiated_by_preparer_flag) --Bug#3107596

Line 945: UPDATE icx_cat_item_prices ip

941: xErrLoc := 400;
942:
943: -- update the existing prices
944: FORALL i in 1..gRowIds.COUNT
945: UPDATE icx_cat_item_prices ip
946: SET (ip.unit_price, ip.currency,
947: ip.unit_of_measure,
948: ip.supplier_site_code, ip.request_id, ip.last_updated_by,
949: ip.last_update_login, ip.last_update_date, ip.contract_num,

Line 976: INSERT into icx_cat_item_prices(rt_item_id, price_type, supplier_site_id, org_id,

972: ELSE
973:
974: -- insert the new prices
975: FORALL i in 1..gRowIds.COUNT
976: INSERT into icx_cat_item_prices(rt_item_id, price_type, supplier_site_id, org_id,
977: active_flag, search_type, unit_price, currency, unit_of_measure,
978: supplier_site_code, price_list_id, request_id, created_by, creation_date,
979: last_updated_by, last_update_login, last_update_date, contract_num, contract_id, object_version_number,
980: negotiated_by_preparer_flag) --Bug#3107596

Line 996: UPDATE icx_cat_item_prices ip

992: xErrLoc := 400;
993:
994: -- update the existing prices
995: FORALL i in 1..gRowIds.COUNT
996: UPDATE icx_cat_item_prices ip
997: SET (ip.unit_price, ip.currency, ip.unit_of_measure, ip.supplier_site_id,
998: ip.supplier_site_code, ip.request_id, ip.last_updated_by, ip.last_update_login, ip.last_update_date, ip.contract_num, ip.contract_id, ip.object_version_number,
999: ip.price_type, --Bug#3503280
1000: negotiated_by_preparer_flag) --Bug#3107596

Line 1025: UPDATE icx_cat_item_prices

1021: -- OEX_IP_PORTING
1022: -- ASL rows for which new bulkloaded price has been added should be set
1023: -- to active_flag = 'N'
1024: FORALL i in 1..gRowIds.COUNT
1025: UPDATE icx_cat_item_prices
1026: SET active_flag = 'N'
1027: WHERE
1028: rt_item_id = gItemIds(i)
1029: AND gSystemActions(i) = p_action

Line 1115: FROM icx_cat_item_prices

1111: active_flag, search_type, unit_price, currency, unit_of_measure,
1112: supplier_site_code, contract_num, contract_line_num, price_list_id, sysdate,
1113: last_update_login, last_updated_by, last_update_date, created_by, creation_date,
1114: request_id, program_application_id, program_id, program_update_date, object_version_number
1115: FROM icx_cat_item_prices
1116: WHERE rt_item_id = gItemIds(i)
1117: AND price_list_id = gPricelistIds(i)
1118: AND org_id = gOrgIds(i)
1119: AND supplier_site_id = gSupplierSiteIds(i)

Line 1134: update icx_cat_item_prices

1130: -- will be set to 'Y'. If the icx_por_ext_item.getBulkLoadActiveFlag returned 'N', the
1131: -- there is a contract/template, So set the active_flag to 'N'
1132: -- (Active flag constraint used to pick the right index.)
1133: FORALL i in 1..gRowIds.COUNT
1134: update icx_cat_item_prices
1135: set active_flag = gActiveFlags(i)
1136: where rt_item_id = gItemIds(i)
1137: and active_flag = 'N'
1138: and org_id = gOrgIds(i)

Line 1148: DELETE from icx_cat_item_prices

1144: xErrLoc := 200;
1145:
1146: -- Now delete the lines from the item_prices table
1147: FORALL i in 1..gRowIds.COUNT
1148: DELETE from icx_cat_item_prices
1149: WHERE rt_item_id = gItemIds(i)
1150: AND price_list_id = gPricelistIds(i)
1151: AND org_id = gOrgIds(i)
1152: AND supplier_site_id = gSupplierSiteIds(i)

Line 1887: FROM icx_cat_item_prices pll

1883: gUserLogin, gUserId, sysdate,
1884: gUserId, sysdate
1885: FROM icx_cat_items_tlp tl,
1886: (SELECT DISTINCT org_id
1887: FROM icx_cat_item_prices pll
1888: WHERE rt_item_id = gCurrentItemIds(i)
1889: ) pll
1890: WHERE tl.rt_item_id = gItemIds(i)
1891: AND gSystemActions(i) = v_action;

Line 2128: FROM icx_cat_item_prices pll

2124: SELECT gItemIds(i), tl.language, v_sequence,
2125: to_char(pll.org_id), pll.org_id
2126: FROM icx_cat_items_tlp tl,
2127: (SELECT DISTINCT org_id
2128: FROM icx_cat_item_prices pll
2129: WHERE rt_item_id = gCurrentItemIds(i)
2130: ) pll
2131: WHERE tl.rt_item_id = gItemIds(i)
2132: AND gSystemActions(i) = v_action;