APPS.AHL_PRD_RESOURCE_TRANX_PVT dependencies on BOM_DEPARTMENTS

Line 75: bom_departments bomdep,

71: WHERE department_id in (
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

Line 591: from ahl_workorder_tasks_v wo, ahl_workorder_operations awo, bom_departments bd,

587: */
588:
589: Select awo.workorder_operation_id, wop.department_id, bd.department_code,
590: wo.organization_id
591: from ahl_workorder_tasks_v wo, ahl_workorder_operations awo, bom_departments bd,
592: wip_operations wop
593: where wo.wip_entity_id = wop.wip_entity_id
594: and wop.operation_seq_num = c_Oper_seq
595: and wop.department_id = bd.department_id

Line 617: From BOM_DEPARTMENTS

613:
614: Cursor CurGetDeptdet(c_department_code Varchar2,c_org_id number)
615: Is
616: Select department_id
617: From BOM_DEPARTMENTS
618: Where department_code=C_department_code
619: and organization_id=c_org_id;
620:
621: l_deptrec CurGetDeptdet%rowtype;

Line 2006: AHL_PP_REQUIREMENT_V APRV,bom_departments BD

2002: APRV.DEPARTMENT_ID,
2003: BD.department_code,
2004: APRV.REQUIREMENT_ID
2005: FROM AHL_WORK_ASSIGNMENTS AWAS,
2006: AHL_PP_REQUIREMENT_V APRV,bom_departments BD
2007: WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID
2008: AND APRV.DEPARTMENT_ID = BD.department_id
2009: AND APRV.JOB_ID = x_workorder_id
2010: AND APRV.OPERATION_SEQUENCE = x_operation_seq_num

Line 2029: AHL_PP_REQUIREMENT_V APRV,bom_departments BD

2025: APRV.DEPARTMENT_ID,
2026: BD.department_code,
2027: APRV.REQUIREMENT_ID
2028: FROM AHL_WORK_ASSIGNMENTS AWAS,
2029: AHL_PP_REQUIREMENT_V APRV,bom_departments BD
2030: WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID
2031: AND APRV.DEPARTMENT_ID = BD.department_id
2032: AND APRV.JOB_ID = x_workorder_id
2033: AND APRV.OPERATION_SEQUENCE = x_operation_seq_num

Line 2049: FROM AHL_PP_REQUIREMENT_V APRV ,bom_departments BD

2045: APRV.UOM_CODE,
2046: APRV.DEPARTMENT_ID,
2047: BD.department_code,
2048: APRV.REQUIREMENT_ID
2049: FROM AHL_PP_REQUIREMENT_V APRV ,bom_departments BD
2050: WHERE APRV.JOB_ID = x_workorder_id
2051: AND APRV.DEPARTMENT_ID = BD.department_id
2052: AND APRV.OPERATION_SEQUENCE = x_operation_seq_num
2053: AND APRV.RESOURCE_TYPE_CODE <> 2

Line 2075: AHL_PP_REQUIREMENT_V APRV ,bom_departments BD

2071: APRV.DEPARTMENT_ID,
2072: BD.department_code,
2073: APRV.REQUIREMENT_ID
2074: FROM AHL_WORK_ASSIGNMENTS AWAS,
2075: AHL_PP_REQUIREMENT_V APRV ,bom_departments BD
2076: WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID
2077: AND APRV.DEPARTMENT_ID = BD.department_id
2078: AND APRV.JOB_ID = x_workorder_id
2079: AND APRV.OPERATION_SEQUENCE = x_operation_seq_num;

Line 2094: FROM AHL_PP_REQUIREMENT_V APRV ,bom_departments BD

2090: APRV.UOM_CODE,
2091: APRV.DEPARTMENT_ID,
2092: BD.department_code,
2093: APRV.REQUIREMENT_ID
2094: FROM AHL_PP_REQUIREMENT_V APRV ,bom_departments BD
2095: WHERE APRV.JOB_ID = x_workorder_id
2096: AND APRV.DEPARTMENT_ID = BD.department_id
2097: AND APRV.OPERATION_SEQUENCE = x_operation_seq_num
2098: AND NOT EXISTS (SELECT ASSIGNMENT_ID