[Home] [Help]
651:
652: CURSOR get_quantity(c_instance_id NUMBER)
653: IS
654: SELECT quantity
655: FROM CSI_ITEM_INSTANCES
656: WHERE instance_id=c_instance_id
657: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(ACTIVE_START_DATE,SYSDATE))
658: AND TRUNC(NVL(ACTIVE_END_DATE,SYSDATE));
659:
989:
990: CURSOR validate_item_instance(c_inv_item_id NUMBER,c_inst_id NUMBER)
991: IS
992: SELECT a.instance_id
993: FROM CSI_ITEM_INSTANCES a
994: WHERE a.inventory_item_id=c_inv_item_id
995: AND a.instance_id=c_inst_id;
996:
997: l_instance_rec validate_item_instance%ROWTYPE;
1478: FND_MSG_PUB.ADD;
1479: ELSE
1480: SELECT COUNT(a.instance_id)
1481: INTO l_dummy_ctr
1482: FROM CSI_ITEM_INSTANCES a,
1483: MTL_SYSTEM_ITEMS b
1484: WHERE a.instance_id=p_prd_workorder_rec.item_instance_id
1485: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(a.active_start_date,SYSDATE))
1486: AND TRUNC(NVL(a.active_end_date,SYSDATE+1))
2864: IS
2865: SELECT
2866: csi.quantity
2867: FROM
2868: csi_item_instances csi,
2869: ahl_visit_tasks_b vtsk
2870: WHERE
2871: vtsk.instance_id = csi.instance_id AND
2872: vtsk.status_code <> 'DELETED' AND
3434:
3435: -- Fix for bug# 5347560.
3436: CURSOR chk_inst_in_job (p_workorder_id IN NUMBER) IS
3437: SELECT 'x'
3438: FROM CSI_ITEM_INSTANCES CII, AHL_WORKORDERS AWO
3439: WHERE CII.WIP_JOB_ID = AWO.WIP_ENTITY_ID
3440: AND AWO.workorder_id = p_workorder_id
3441: AND ACTIVE_START_DATE <= SYSDATE
3442: AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))
3499: IS
3500: SELECT
3501: csi.quantity
3502: FROM
3503: csi_item_instances csi,
3504: ahl_visit_tasks_b vtsk
3505: WHERE
3506: vtsk.instance_id = csi.instance_id AND
3507: vtsk.status_code <> 'DELETED' AND