DBA Data[Home] [Help]

APPS.AHL_PRD_RESOURCE_TRANX_PVT dependencies on BOM_DEPARTMENT_RESOURCES

Line 76: bom_department_resources bodres

72: select
73: distinct nvl(bodres.share_from_dept_id, bodres.department_id)
74: from
75: bom_departments bomdep,
76: bom_department_resources bodres
77: where
78: bodres.department_id = bomdep.department_id and
79: bomdep.department_id = c_department_id and
80: bomdep.organization_id = c_organization_id

Line 648: FROM BOM_RESOURCES BR, BOM_DEPARTMENT_RESOURCES BDR, ahl_operation_resources aor

644: p_dept_id IN NUMBER,
645: p_workorder_operation_id IN NUMBER)
646: Is
647: SELECT BR.RESOURCE_ID, aor.resource_sequence_num, BR.UNIT_OF_MEASURE UOM_CODE
648: FROM BOM_RESOURCES BR, BOM_DEPARTMENT_RESOURCES BDR, ahl_operation_resources aor
649: WHERE BR.RESOURCE_ID = BDR.RESOURCE_ID
650: AND BDR.DEPARTMENT_ID = p_dept_id
651: AND BR.RESOURCE_CODE = p_resource_code
652: AND BR.ORGANIZATION_ID = p_org_id