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 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