[Home] [Help]
1094: BEGIN
1095: l_err_loc := 100;
1096: SELECT 'UPDATE'
1097: INTO l_action
1098: FROM po_attribute_values_tlp
1099: WHERE po_line_id = p_po_line_id
1100: AND req_template_name = p_req_template_name
1101: AND req_template_line_num = p_req_template_line_num
1102: AND org_id = p_org_id
4363: price.price_type, itemtlp.primary_category_name
4364: FROM icx_cat_r12_upg_autosource src, icx_cat_item_prices price,
4365: icx_cat_items_tlp itemtlp, icx_por_category_order_map map,
4366: icx_cat_items_b itemb, icx_cat_ext_items_tlp extitemtlp,
4367: icx_cat_r12_upgrade upg, po_attribute_values_tlp attr
4368: WHERE price.price_type = 'BULKLOAD'
4369: AND price.rt_item_id = itemtlp.rt_item_id
4370: AND NOT EXISTS (SELECT 'extracted price'
4371: FROM icx_cat_item_prices priceIn
4420: price.price_type, itemtlp.primary_category_name
4421: FROM icx_cat_item_prices price, icx_cat_items_tlp itemtlp,
4422: icx_por_category_order_map map,
4423: icx_cat_items_b itemb, icx_cat_ext_items_tlp extitemtlp,
4424: icx_cat_r12_upgrade upg, po_attribute_values_tlp attr
4425: WHERE price.price_type = 'CONTRACT'
4426: AND price.rt_item_id = itemtlp.rt_item_id
4427: AND NOT EXISTS (SELECT 'extracted price'
4428: FROM icx_cat_item_prices priceIn
7704: des1.created_by, des1.creation_date,
7705: des1.last_updated_by, des1.last_update_login, des1.last_update_date,
7706: des1.batch_job_num, des1.program_application_id, des1.program_id,
7707: des1.rebuild_flag, des1.section_tag,
7708: DECODE(des1.type, 2, 'PO_ATTRIBUTE_VALUES_TLP', 'PO_ATTRIBUTE_VALUES'),
7709: des1.stored_in_column
7710: FROM
7711: icx_cat_descriptors_tl des1
7712: WHERE des1.rt_descriptor_id > 100