APPS.AHL_COMPLETIONS_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 254: AHL_UNIT_EFFECTIVITIES_B UE

250: CSI.lot_number,
251: CSI.serial_number,
252: CSI.quantity
253: FROM AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS, CSI_ITEM_INSTANCES CSI,
254: AHL_UNIT_EFFECTIVITIES_B UE
255: WHERE VTS.unit_effectivity_id = UE.unit_effectivity_id
256: AND NVL(VTS.instance_id, VST.item_instance_id) = CSI.instance_id
257: AND VST.visit_id = VTS.visit_id
258: AND VTS.visit_task_id = c_visit_task_id;

Line 1929: FROM AHL_UNIT_EFFECTIVITIES_B

1925: IS
1926: SELECT mr_header_id,
1927: unit_effectivity_id,
1928: status_code
1929: FROM AHL_UNIT_EFFECTIVITIES_B
1930: WHERE unit_effectivity_id IN
1931: (
1932: SELECT related_ue_id
1933: FROM AHL_UE_RELATIONSHIPS

Line 1947: FROM AHL_UNIT_EFFECTIVITIES_B UE, (

1943: IS
1944: SELECT mr_header_id,
1945: unit_effectivity_id,
1946: status_code
1947: FROM AHL_UNIT_EFFECTIVITIES_B UE, (
1948: SELECT related_ue_id
1949: FROM AHL_UE_RELATIONSHIPS
1950: START WITH ue_id = c_unit_effectivity_id
1951: AND relationship_code = 'PARENT'

Line 3118: FROM AHL_UNIT_EFFECTIVITIES_B UE,(

3114: );*/
3115: CURSOR Check_child_exists (c_unit_effectivity_id IN NUMBER)
3116: IS
3117: SELECT 1
3118: FROM AHL_UNIT_EFFECTIVITIES_B UE,(
3119: SELECT related_ue_id
3120: FROM AHL_UE_RELATIONSHIPS
3121: START WITH ue_id = c_unit_effectivity_id
3122: AND relationship_code = 'PARENT'

Line 3959: AHL_UNIT_EFFECTIVITIES_B UE,

3955: IS
3956: SELECT UE.unit_effectivity_id unit_effectivity_id,
3957: UE.object_version_number ue_object_version_number
3958: FROM AHL_MR_HEADERS_B MR,
3959: AHL_UNIT_EFFECTIVITIES_B UE,
3960: AHL_UE_RELATIONSHIPS REL
3961: WHERE MR.mr_header_id = UE.mr_header_id
3962: AND MR.auto_signoff_flag = 'Y'
3963: AND UE.unit_effectivity_id = REL.ue_id

Line 5671: FROM AHL_UNIT_EFFECTIVITIES_B UE,(SELECT related_ue_id

5667: status_code ump_status_code,
5668: DECODE( UE.Mr_header_id, null,null,(select QA_INSPECTION_TYPE from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) qa_inspection_type_code,
5669: -1 qa_plan_id,
5670: qa_collection_id
5671: FROM AHL_UNIT_EFFECTIVITIES_B UE,(SELECT related_ue_id
5672: FROM AHL_UE_RELATIONSHIPS
5673: START WITH ue_id = c_unit_effectivity_id
5674: AND relationship_code = 'PARENT'
5675: CONNECT BY ue_id = PRIOR related_ue_id

Line 7819: FROM AHL_UNIT_EFFECTIVITIES_B UE,

7815: UE.status_code ump_status_code,
7816: DECODE( UE.Mr_header_id, null,null,(select QA_INSPECTION_TYPE from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) qa_inspection_type_code,
7817: -1 qa_plan_id,
7818: UE.qa_collection_id qa_collection_id
7819: FROM AHL_UNIT_EFFECTIVITIES_B UE,
7820: AHL_VISIT_TASKS_B VT,
7821: ahl_workorders awo
7822: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
7823: AND ( (VT.task_type_code = 'SUMMARY')

Line 7883: FROM AHL_UNIT_EFFECTIVITIES_B UE,(SELECT related_ue_id

7879: status_code ump_status_code,
7880: DECODE( UE.Mr_header_id, null,null,(select QA_INSPECTION_TYPE from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) qa_inspection_type_code,
7881: -1 qa_plan_id,
7882: qa_collection_id
7883: FROM AHL_UNIT_EFFECTIVITIES_B UE,(SELECT related_ue_id
7884: FROM AHL_UE_RELATIONSHIPS
7885: START WITH ue_id = c_unit_effectivity_id
7886: AND relationship_code = 'PARENT'
7887: CONNECT BY ue_id = PRIOR related_ue_id

Line 9579: AHL_UNIT_EFFECTIVITIES_B UE

9575: WO.wip_entity_id wip_entity_id
9576: FROM AHL_WORKORDERS WO,
9577: AHL_VISIT_TASKS_B VT,
9578: --AHL_UE_DEFERRAL_DETAILS_V UE
9579: AHL_UNIT_EFFECTIVITIES_B UE
9580: WHERE WO.visit_task_id = VT.visit_task_id
9581: AND VT.task_type_code IN ( 'SUMMARY' , 'UNASSOCIATED' )
9582: AND VT.unit_effectivity_id = UE.unit_effectivity_id
9583: AND UE.unit_effectivity_id = c_unit_effectivity_id;

Line 10898: from ahl_unit_effectivities_b UE--, FND_LOOKUP_VALUES_VL FL

10894: UE.cs_incident_id,
10895: --FL.Lookup_code,
10896: --FL.Meaning,
10897: UE.qa_collection_id
10898: from ahl_unit_effectivities_b UE--, FND_LOOKUP_VALUES_VL FL
10899: where --FL.Lookup_type = 'AHL_PRD_MR_STATUS'
10900: --AND FL.Lookup_code = AHL_COMPLETIONS_PVT.get_mr_status( p_unit_effectivity_id ) AND
10901: UE.unit_effectivity_id = p_unit_effectivity_id
10902: AND UE.object_version_number = p_ue_object_version_no;