APPS.AHL_UMP_NONROUTINES_PVT dependencies on CSI_ITEM_INSTANCES

Line 217: FROM csi_item_instances

213: inv_master_organization_id
214: INTO p_x_nonroutine_rec.inventory_item_id,
215: l_service_request_rec.inventory_item_id,
216: l_service_request_rec.inventory_org_id
217: FROM csi_item_instances
218: WHERE instance_id = p_x_nonroutine_rec.instance_id;
219:
220: l_service_request_rec.customer_product_id := p_x_nonroutine_rec.instance_id;
221: l_service_request_rec.creation_program_code := 'AHL_NONROUTINE';

Line 758: FROM csi_item_instances

754: SELECT p_x_nonroutine_rec.inventory_item_id,
755: inv_master_organization_id
756: INTO l_service_request_rec.inventory_item_id,
757: l_service_request_rec.inventory_org_id
758: FROM csi_item_instances
759: WHERE instance_id = p_x_nonroutine_rec.instance_id;
760: */
761: --apattark end for fp bug #9557752
762:

Line 3000: FROM csi_item_instances csi

2996: -- There is no need to join with MTL/HOU since this is just a instance_number to instance_id validation,
2997: -- the check for whether the instance exists on an active unit is being done in Validate_UE_Details
2998: SELECT csi.instance_id
2999: INTO p_x_nonroutine_rec.instance_id
3000: FROM csi_item_instances csi
3001: WHERE trunc(nvl(csi.active_start_date, sysdate)) <= trunc(sysdate) and
3002: trunc(nvl(csi.active_end_date, sysdate+1)) > trunc(sysdate) and
3003: csi.instance_number = p_x_nonroutine_rec.instance_number;
3004: EXCEPTION

Line 3107: FROM csi_item_instances

3103:
3104: -- Retrieve instance customer id
3105: SELECT NVL(OWNER_PARTY_ID, -1)
3106: INTO l_instance_owner_id
3107: FROM csi_item_instances
3108: WHERE instance_id = p_x_nonroutine_rec.instance_id;
3109:
3110: -- Validate and default customer...
3111: IF (p_x_nonroutine_rec.customer_name IS NOT NULL AND p_x_nonroutine_rec.customer_name <> FND_API.G_MISS_CHAR)