DBA Data[Home] [Help]

APPS.AHL_UA_COMMON_PVT dependencies on BOM_DEPARTMENTS

Line 803: BOM_DEPARTMENTS BDPT

799: VB.UNIT_SCHEDULE_ID
800: FROM AHL_VISITS_B VB,
801: AHL_UNIT_CONFIG_HEADERS UC,
802: HR_ALL_ORGANIZATION_UNITS HROU,
803: BOM_DEPARTMENTS BDPT
804: WHERE
805: VB.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+) AND
806: VB.DEPARTMENT_ID = BDPT.DEPARTMENT_ID(+) AND
807: VB.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID AND

Line 870: BOM_DEPARTMENTS BDPT

866: FROM
867: AHL_VISITS_B VB,
868: AHL_UNIT_CONFIG_HEADERS UC,
869: HR_ALL_ORGANIZATION_UNITS HROU,
870: BOM_DEPARTMENTS BDPT
871: WHERE
872: VB.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+) AND
873: VB.DEPARTMENT_ID = BDPT.DEPARTMENT_ID(+) AND
874: VB.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID AND

Line 1174: BOM_DEPARTMENTS BDPT

1170: VB.UNIT_SCHEDULE_ID
1171: FROM AHL_VISITS_B VB,
1172: AHL_UNIT_CONFIG_HEADERS UC,
1173: HR_ALL_ORGANIZATION_UNITS HROU,
1174: BOM_DEPARTMENTS BDPT
1175: WHERE
1176: VB.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+) AND
1177: VB.DEPARTMENT_ID = BDPT.DEPARTMENT_ID(+) AND
1178: VB.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID AND

Line 1238: BOM_DEPARTMENTS BDPT

1234: FROM
1235: AHL_VISITS_B VB,
1236: AHL_UNIT_CONFIG_HEADERS UC,
1237: HR_ALL_ORGANIZATION_UNITS HROU,
1238: BOM_DEPARTMENTS BDPT
1239: WHERE
1240: VB.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+) AND
1241: VB.DEPARTMENT_ID = BDPT.DEPARTMENT_ID(+) AND
1242: VB.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID AND