[Home] [Help]
643: AND trunc(nvl(end_date_active,sysdate))
644: AND upper(meaning) = upper(p_meaning);
645:
646: CURSOR sr_customer_product(p_instance_number IN VARCHAR2) IS
647: SELECT instance_id FROM csi_item_instances
648: WHERE instance_number = p_instance_number;
649:
650: CURSOR ahl_visit(p_visit_number IN NUMBER) IS
651: SELECT visit_id FROM ahl_visits_b
653: -- Begin Changes by VSUNDARA
654: -- TO validate the Instance Owner
655: CURSOR ahl_instance_owner(p_instance_number IN VARCHAR2) IS
656: SELECT OWNER_PARTY_ID
657: FROM csi_item_instances
658: WHERE instance_number = p_instance_number;
659: -- END Changes
660:
661: BEGIN
1300:
1301: -- Changes made by by VSUNDARA For SR Integration
1302: CURSOR default_party_id(p_item_instance_number IN NUMBER) IS
1303: SELECT OWNER_PARTY_ID
1304: FROM csi_item_instances
1305: WHERE instance_id = p_item_instance_number;
1306:
1307: CURSOR owner_customer_type(p_cust_id IN NUMBER) IS
1308: SELECT party_type
1314:
1315: --amsriniv ER 6014567 Begin
1316: CURSOR check_inst_nonserial(c_instance_id IN NUMBER, c_workorder_id IN NUMBER) IS
1317: SELECT 'X'
1318: FROM mtl_system_items_b mtl, csi_item_instances csi
1319: WHERE csi.instance_id = c_instance_id
1320: AND csi.inventory_item_id = mtl.inventory_item_id
1321: AND mtl.organization_id = (SELECT organization_id from wip_discrete_jobs wdj, ahl_workorders awo where wdj.wip_entity_id = awo.wip_entity_id and awo.workorder_id = c_workorder_id)
1322: AND mtl.serial_number_control_code = 1;
1322: AND mtl.serial_number_control_code = 1;
1323:
1324: CURSOR validate_quantity(c_instance_id IN NUMBER, c_wo_id IN NUMBER) IS
1325: SELECT csi.quantity
1326: FROM CSI_ITEM_INSTANCES csi,
1327: ahl_workorders wo
1328: WHERE csi.instance_id = c_instance_id
1329: AND csi.wip_job_id = WO.WIP_ENTITY_ID
1330: AND wo.workorder_id = c_wo_id
2868: where workorder_id = p_wo_id;
2869: Cursor GetInstanceNumber
2870: Is
2871: Select instance_number
2872: from csi_item_instances
2873: where instance_id = p_instance_id;
2874: BEGIN
2875: Open GetWoName;
2876: Fetch GetWoName into x_wo_name;
2909: Is
2910: Select ci.instance_number,
2911: ci.serial_number,
2912: msi.concatenated_segments
2913: from csi_item_instances ci,
2914: mtl_system_items_kfv msi
2915: where ci.instance_id = p_sr_task_rec.instance_id
2916: and ci.inventory_item_id = msi.inventory_item_id
2917: and ci.inv_master_organizatiOn_id = msi.organization_id;