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 1964: AHL_PP_REQUIREMENT_V APRV,bom_departments BD

1960: APRV.DEPARTMENT_ID,
1961: BD.department_code,
1962: APRV.REQUIREMENT_ID
1963: FROM AHL_WORK_ASSIGNMENTS AWAS,
1964: AHL_PP_REQUIREMENT_V APRV,bom_departments BD
1965: WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID
1966: AND APRV.DEPARTMENT_ID = BD.department_id
1967: AND APRV.JOB_ID = x_workorder_id
1968: AND APRV.OPERATION_SEQUENCE = x_operation_seq_num

Line 1987: AHL_PP_REQUIREMENT_V APRV,bom_departments BD

1983: APRV.DEPARTMENT_ID,
1984: BD.department_code,
1985: APRV.REQUIREMENT_ID
1986: FROM AHL_WORK_ASSIGNMENTS AWAS,
1987: AHL_PP_REQUIREMENT_V APRV,bom_departments BD
1988: WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID
1989: AND APRV.DEPARTMENT_ID = BD.department_id
1990: AND APRV.JOB_ID = x_workorder_id
1991: AND APRV.OPERATION_SEQUENCE = x_operation_seq_num

Line 2007: FROM AHL_PP_REQUIREMENT_V APRV ,bom_departments BD

2003: APRV.UOM_CODE,
2004: APRV.DEPARTMENT_ID,
2005: BD.department_code,
2006: APRV.REQUIREMENT_ID
2007: FROM AHL_PP_REQUIREMENT_V APRV ,bom_departments BD
2008: WHERE APRV.JOB_ID = x_workorder_id
2009: AND APRV.DEPARTMENT_ID = BD.department_id
2010: AND APRV.OPERATION_SEQUENCE = x_operation_seq_num
2011: AND APRV.RESOURCE_TYPE_CODE <> 2

Line 2033: AHL_PP_REQUIREMENT_V APRV ,bom_departments BD

2029: APRV.DEPARTMENT_ID,
2030: BD.department_code,
2031: APRV.REQUIREMENT_ID
2032: FROM AHL_WORK_ASSIGNMENTS AWAS,
2033: AHL_PP_REQUIREMENT_V APRV ,bom_departments BD
2034: WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID
2035: AND APRV.DEPARTMENT_ID = BD.department_id
2036: AND APRV.JOB_ID = x_workorder_id
2037: AND APRV.OPERATION_SEQUENCE = x_operation_seq_num;

Line 2052: FROM AHL_PP_REQUIREMENT_V APRV ,bom_departments BD

2048: APRV.UOM_CODE,
2049: APRV.DEPARTMENT_ID,
2050: BD.department_code,
2051: APRV.REQUIREMENT_ID
2052: FROM AHL_PP_REQUIREMENT_V APRV ,bom_departments BD
2053: WHERE APRV.JOB_ID = x_workorder_id
2054: AND APRV.DEPARTMENT_ID = BD.department_id
2055: AND APRV.OPERATION_SEQUENCE = x_operation_seq_num
2056: AND NOT EXISTS (SELECT ASSIGNMENT_ID