APPS.AHL_PRD_RESOURCE_TRANX_PVT dependencies on BOM_RESOURCES

Line 37: FROM BOM_RESOURCES bomr,

33: -- c_res_seq_num NUMBER)
34: IS
35: SELECT bomr.resource_code,
36: bomr.resource_type, aor.resource_sequence_num
37: FROM BOM_RESOURCES bomr,
38: AHL_WORKORDER_OPERATIONS awop,
39: AHL_OPERATION_RESOURCES aor
40: WHERE awop.workorder_operation_id = aor.workorder_operation_id(+)
41: AND bomr.resource_id = aor.resource_id(+)

Line 54: FROM BOM_RESOURCES bomr

50: c_res_code VARCHAR2)
51: --
52: IS
53: SELECT bomr.resource_code, bomr.resource_type
54: FROM BOM_RESOURCES bomr
55: WHERE bomr.organization_id = c_org_id
56: and bomr.resource_code = c_res_code;
57:
58: /*Select * from bom_resources

Line 58: /*Select * from bom_resources

54: FROM BOM_RESOURCES bomr
55: WHERE bomr.organization_id = c_org_id
56: and bomr.resource_code = c_res_code;
57:
58: /*Select * from bom_resources
59: where resource_code=c_resource_name
60: and organization_id=c_org_id;*/
61: l_res_rec GetResourceDet%rowtype;
62:

Line 606: from ahl_operation_resources a, bom_resources br

602:
603: Cursor CurGetResSeq(c_workorder_operation_id number,c_res_seq number)
604: Is
605: Select a.resource_id, BR.UNIT_OF_MEASURE UOM_CODE, br.resource_code
606: from ahl_operation_resources a, bom_resources br
607: where a.resource_id = br.resource_id
608: and a.workorder_operation_id = c_workorder_operation_id
609: and resource_sequence_num=c_res_seq;
610:

Line 628: FROM AHL_OPERATION_RESOURCES AOR, AHL_WORKORDER_OPERATIONS AWO , BOM_RESOURCES BOM, MFG_LOOKUPS MFG

624: /*
625: Cursor Curres(WORK_ID NUMBER,C_RES_SEQ NUMBER)
626: Is
627: Select AOR.RESOURCE_ID, BOM.UNIT_OF_MEASURE UOM_CODE
628: FROM AHL_OPERATION_RESOURCES AOR, AHL_WORKORDER_OPERATIONS AWO , BOM_RESOURCES BOM, MFG_LOOKUPS MFG
629: WHERE AOR.RESOURCE_SEQUENCE_NUM = C_RES_SEQ
630: AND AOR.WORKORDER_OPERATION_ID = AWO.WORKORDER_OPERATION_ID
631: AND AWO.WORKORDER_ID = WORK_ID
632: AND AOR.RESOURCE_ID = BOM.RESOURCE_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

Line 1609: AHL_OPERATION_RESOURCES AOPR,AHL_DEPARTMENT_SHIFTS ADS, mtl_employees_current_view PEPF, BOM_RESOURCES BOMR, MFG_LOOKUPS MFGL

1605: AWOS.DEPARTMENT_NAME,
1606: AWOS.DEPARTMENT_ID,
1607: AWOS.ITEM_INSTANCE_ID
1608: FROM AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDER_TASKS_V AWOS, AHL_WORKORDER_OPERATIONS AWOP,
1609: AHL_OPERATION_RESOURCES AOPR,AHL_DEPARTMENT_SHIFTS ADS, mtl_employees_current_view PEPF, BOM_RESOURCES BOMR, MFG_LOOKUPS MFGL
1610: WHERE AWAS.OPERATION_RESOURCE_ID = AOPR.OPERATION_RESOURCE_ID
1611: AND AWOP.WORKORDER_OPERATION_ID = AOPR.WORKORDER_OPERATION_ID
1612: AND AWOP.WORKORDER_ID = AWOS.WORKORDER_ID
1613: AND AWOS.DEPARTMENT_ID = ADS.DEPARTMENT_ID (+)