APPS.AHL_VWP_VISITS_PVT dependencies on CS_INCIDENTS_ALL_B

Line 1012: PA_PROJECTS_ALL PA, AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB

1008: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU,
1009: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1010: FND_LOOKUP_VALUES_VL FLVT, FND_LOOKUP_VALUES_VL FLVT1,
1011: FND_LOOKUP_VALUES_VL FLVT2, FND_LOOKUP_VALUES_VL FLVT3,
1012: PA_PROJECTS_ALL PA, AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB
1013: WHERE AVTS.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID(+)
1014: AND AVTS.ITEM_INSTANCE_ID = CSIS.INSTANCE_ID(+)
1015: AND AVTS.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+)
1016: AND AVTS.DEPARTMENT_ID = BDPT.DEPARTMENT_ID(+)

Line 1061: AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB

1057: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1058: FND_LOOKUP_VALUES FLVT, FND_LOOKUP_VALUES FLVT1,
1059: FND_LOOKUP_VALUES FLVT2, FND_LOOKUP_VALUES FLVT3,
1060: PA_PROJECTS_ALL PA,
1061: AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB
1062: WHERE AVTS.VISIT_ID = AVTSTL.VISIT_ID
1063: AND AVTSTL.LANGUAGE = USERENV('LANG')
1064: AND ASPV.SIMULATION_PLAN_ID = ASPVTL.SIMULATION_PLAN_ID(+)
1065: AND ASPVTL.LANGUAGE(+) = USERENV('LANG')

Line 5214: FROM cs_incidents_all_b

5210: AND b.service_request_id = x_sr_id);
5211:
5212: CURSOR c_sr_ovn(x_sr_id IN NUMBER) IS
5213: SELECT object_version_number, incident_number
5214: FROM cs_incidents_all_b
5215: WHERE INCIDENT_ID = x_sr_id;
5216: c_sr_ovn_rec c_sr_ovn%ROWTYPE;
5217: -- yazhou end
5218: