[Home] [Help]
113:
114: CURSOR c_del_det IS
115: SELECT inventory_item_id, inventory_item_org_id,
116: pricelist_header_id , nvl(qp.currency_code,'USD') currency_code
117: FROM ams_deliverables_vl del,qp_list_headers_vl qp
118: WHERE del.deliverable_id = p_deliv_id
119: AND del.pricelist_header_id = qp.list_header_id ;
120:
121: l_del_rec c_del_det%ROWTYPE ;
122:
123: CURSOR c_kit_det IS
124: SELECT inventory_item_id, inventory_item_org_id,
125: pricelist_header_id , nvl(qp.currency_code,'USD') currency_code
126: FROM ams_deliverables_vl del,qp_list_headers_vl qp
127: WHERE del.deliverable_id = p_deliv_id
128: AND del.pricelist_header_id = qp.list_header_id ;
129:
130: l_kit_rec c_del_det%ROWTYPE ;
1293: CURSOR c_kit_det IS
1294: SELECT deli.jtf_amv_item_id ,
1295: deli.deliverable_name,
1296: deli.kit_flag
1297: FROM ams_deliverables_vl deli,ams_deliv_kit_items kit
1298: WHERE kit.deliverable_kit_id = p_deliv_id
1299: AND kit.deliverable_kit_part_id = deli.deliverable_id
1300: AND deli.can_fulfill_electronic_flag = 'Y' ;
1301:
1480: --CURSOR c_csch_det IS
1481: -- SELECT deli.jtf_amv_item_id,deli.kit_flag,deli.deliverable_name,
1482: -- deli.can_fulfill_electronic_flag,
1483: -- csch.activity_type_code, csch.activity_id
1484: -- FROM ams_campaign_schedules_b csch, ams_deliverables_vl deli, ams_object_associations assoc
1485: -- WHERE csch.schedule_id = p_act_id
1486: -- AND assoc.master_object_type = 'CSCH'
1487: -- AND assoc.master_object_id= p_act_id
1488: -- AND assoc.using_object_type = 'DELV'
1506:
1507:
1508: --CURSOR c_kit_det IS
1509: -- SELECT deli.can_fulfill_electronic_flag
1510: -- FROM ams_deliverables_vl deli,ams_deliv_kit_items kit
1511: -- WHERE kit.deliverable_kit_id = l_deli_id
1512: -- AND kit.deliverable_kit_part_id = deli.deliverable_id;
1513:
1514: