[Home] [Help]
707: AND trunc(nvl(end_date_active,sysdate))
708: AND upper(meaning) = upper(p_meaning);
709:
710: CURSOR sr_customer_product(p_instance_number IN VARCHAR2) IS
711: SELECT instance_id FROM csi_item_instances
712: WHERE instance_number = p_instance_number;
713:
714: CURSOR ahl_visit(p_visit_number IN NUMBER) IS
715: SELECT visit_id FROM ahl_visits_b
717: -- Begin Changes by VSUNDARA
718: -- TO validate the Instance Owner
719: CURSOR ahl_instance_owner(p_instance_number IN VARCHAR2) IS
720: SELECT OWNER_PARTY_ID
721: FROM csi_item_instances
722: WHERE instance_number = p_instance_number;
723: -- END Changes
724:
725: -- added to fix bug# 8265902
1437:
1438: -- Changes made by by VSUNDARA For SR Integration
1439: CURSOR default_party_id(p_item_instance_number IN NUMBER) IS
1440: SELECT OWNER_PARTY_ID
1441: FROM csi_item_instances
1442: WHERE instance_id = p_item_instance_number;
1443:
1444: CURSOR owner_customer_type(p_cust_id IN NUMBER) IS
1445: SELECT party_type
1462:
1463: --amsriniv ER 6014567 Begin
1464: CURSOR check_inst_nonserial(c_instance_id IN NUMBER, c_workorder_id IN NUMBER) IS
1465: SELECT 'X'
1466: FROM mtl_system_items_b mtl, csi_item_instances csi
1467: WHERE csi.instance_id = c_instance_id
1468: AND csi.inventory_item_id = mtl.inventory_item_id
1469: 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)
1470: AND mtl.serial_number_control_code = 1;
1470: AND mtl.serial_number_control_code = 1;
1471:
1472: CURSOR validate_quantity(c_instance_id IN NUMBER, c_wo_id IN NUMBER) IS
1473: SELECT csi.quantity
1474: FROM CSI_ITEM_INSTANCES csi,
1475: ahl_workorders wo
1476: WHERE csi.instance_id = c_instance_id
1477: AND csi.wip_job_id = WO.WIP_ENTITY_ID
1478: AND wo.workorder_id = c_wo_id
3533: where workorder_id = p_wo_id;
3534: Cursor GetInstanceNumber
3535: Is
3536: Select instance_number
3537: from csi_item_instances
3538: where instance_id = p_instance_id;
3539: BEGIN
3540: Open GetWoName;
3541: Fetch GetWoName into x_wo_name;
3574: Is
3575: Select ci.instance_number,
3576: ci.serial_number,
3577: msi.concatenated_segments
3578: from csi_item_instances ci,
3579: mtl_system_items_kfv msi
3580: where ci.instance_id = p_sr_task_rec.instance_id
3581: and ci.inventory_item_id = msi.inventory_item_id
3582: and ci.inv_master_organizatiOn_id = msi.organization_id;