APPS.AHL_PRD_RESOURCE_TRANX_PVT dependencies on AHL_PP_REQUIREMENT_V

Line 98: --, ahl_pp_requirement_v aprv

94: p_emp_num in varchar2)
95: IS
96: SELECT 'x'
97: FROM mtl_employees_current_view pf, bom_resource_employees bre, bom_dept_res_instances bdri
98: --, ahl_pp_requirement_v aprv
99: WHERE --aprv.department_id = bdri.department_id
100: --and aprv.RESOURCE_ID= bdri.resource_id
101: --and
102: bre.instance_id = bdri.instance_id

Line 125: --ahl_pp_requirement_v aprv

121:
122: IS
123: SELECT 'x'
124: FROM bom_resource_employees bre, bom_dept_res_instances bdri --,
125: --ahl_pp_requirement_v aprv
126: WHERE --aprv.department_id = bdri.department_id
127: --and aprv.RESOURCE_ID= bdri.resource_id
128: --and
129: bre.instance_id = bdri.instance_id

Line 638: From AHL_PP_REQUIREMENT_V

634: AND MFG.LOOKUP_CODE(+) = BOM.RESOURCE_TYPE;
635: */
636:
637: /*Select * -- resource_id, UOM_CODE
638: From AHL_PP_REQUIREMENT_V
639: Where JOB_ID=WORK_ID
640: AND RESOURCE_SEQUENCE=C_RES_SEQ;*/
641:
642: Cursor getResID(p_resource_code IN VARCHAR2,

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