APPS.AHL_PRD_DF_PVT dependencies on CSI_ITEM_INSTANCES

Line 976: FROM ahl_unit_effectivities_b ue, csi_item_instances cii

972: -- SR Cancellation for nonserialized items.
973: CURSOR is_orig_ue_nonserial(p_ue_id in number)
974: IS
975: SELECT cii.serial_number
976: FROM ahl_unit_effectivities_b ue, csi_item_instances cii
977: WHERE unit_effectivity_id in (select originator_ue_id
978: from ahl_ue_relationships
979: where related_ue_id = p_ue_id)
980: AND ue.csi_item_instance_id = cii.instance_id

Line 988: FROM ahl_unit_effectivities_b ue, csi_item_instances cii

984: -- SR Cancellation for nonserialized items.
985: CURSOR is_sr_ue_nonserial(p_ue_id in number)
986: IS
987: SELECT cii.serial_number
988: FROM ahl_unit_effectivities_b ue, csi_item_instances cii
989: WHERE unit_effectivity_id = p_ue_id
990: AND ue.csi_item_instance_id = cii.instance_id
991: AND cii.quantity > 0
992: AND ue.object_type = 'SR';

Line 995: l_serial_number csi_item_instances.serial_number%TYPE;

991: AND cii.quantity > 0
992: AND ue.object_type = 'SR';
993:
994: l_exists VARCHAR2(1);
995: l_serial_number csi_item_instances.serial_number%TYPE;
996: l_mr_applicable VARCHAR2(1);
997: l_active_end_date DATE;
998: l_new_mr_header_id NUMBER;
999: l_new_mr_applicable VARCHAR2(1);

Line 3942: FROM CSI_ITEM_INSTANCES CII, AHL_WORKORDERS AWO

3938:
3939: -- fix for bug number 6990380
3940: CURSOR chk_inst_in_job (p_workorder_id IN NUMBER) IS
3941: SELECT 'x'
3942: FROM CSI_ITEM_INSTANCES CII, AHL_WORKORDERS AWO
3943: WHERE CII.WIP_JOB_ID = AWO.WIP_ENTITY_ID
3944: AND AWO.workorder_id = p_workorder_id
3945: AND ACTIVE_START_DATE <= SYSDATE
3946: AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))

Line 4574: FROM ahl_unit_effectivities_b ue, csi_item_instances cii

4570: -- SR Cancellation for nonserialized items.
4571: CURSOR is_sr_ue_nonserial(p_ue_id in number)
4572: IS
4573: SELECT cii.serial_number
4574: FROM ahl_unit_effectivities_b ue, csi_item_instances cii
4575: WHERE unit_effectivity_id = p_ue_id
4576: AND ue.csi_item_instance_id = cii.instance_id
4577: AND cii.quantity > 0
4578: AND ue.object_type = 'SR';

Line 4579: l_serial_number csi_item_instances.serial_number%TYPE;

4575: WHERE unit_effectivity_id = p_ue_id
4576: AND ue.csi_item_instance_id = cii.instance_id
4577: AND cii.quantity > 0
4578: AND ue.object_type = 'SR';
4579: l_serial_number csi_item_instances.serial_number%TYPE;
4580:
4581: CURSOR is_initdue_def(p_ue_id in number)IS
4582: SELECT unit_deferral_id from ahl_unit_deferrals_b
4583: WHERE unit_effectivity_id = p_ue_id

Line 5507: SELECT 'X' FROM csi_item_instances csi, ahl_unit_effectivities_b ue

5503: l_new_mr_header_id NUMBER;
5504: l_new_mr_applicable VARCHAR2(1);
5505:
5506: CURSOR is_ue_inst_serial_ctld(p_unit_effectivity_id IN NUMBER)IS
5507: SELECT 'X' FROM csi_item_instances csi, ahl_unit_effectivities_b ue
5508: WHERE ue.UNIT_EFFECTIVITY_ID = p_unit_effectivity_id
5509: AND csi.instance_id = ue.CSI_ITEM_INSTANCE_ID AND csi.SERIAL_NUMBER IS NOT NULL;
5510:
5511: BEGIN

Line 5966: from ahl_mr_headers_b MR,ahl_unit_effectivities_b UE, csi_item_instances ii

5962: -- added active_end_date to fix bug# 12776603; sorao for backporting project
5963: CURSOR get_mr_details_csr(p_unit_effectivity_id IN NUMBER) IS
5964: SELECT MR.mr_header_id,MR.title,MR.effective_from,MR.effective_to,MR.version_number,UE.csi_item_instance_id,
5965: ii.active_end_date
5966: from ahl_mr_headers_b MR,ahl_unit_effectivities_b UE, csi_item_instances ii
5967: WHERE MR.mr_header_id = UE.mr_header_id
5968: AND UE.csi_item_instance_id = ii.instance_id
5969: AND UE.unit_effectivity_id = p_unit_effectivity_id;
5970: