APPS.AHL_PRD_RESOURCE_TRANX_PVT dependencies on AHL_OPERATION_RESOURCES

Line 39: AHL_OPERATION_RESOURCES aor

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(+)
42: AND awop.operation_sequence_num = c_op_seq_num
43: --AND aor.resource_sequence_num = c_res_seq_num

Line 303: From AHL_OPERATION_RESOURCES A

299: and p_prd_resrc_txn_tbl(I).resource_sequence_num<>fnd_api.g_miss_num
300: Then
301: --Select count(*) into l_ctr
302: Select 1 into l_ctr
303: From AHL_OPERATION_RESOURCES A
304: WHERE A.WORKORDER_OPERATION_ID=p_prd_resrc_txn_tbl(I).workorder_OPERATION_id
305: AND A.RESOURCE_SEQUENCE_NUM=p_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_NUM;
306:
307: IF nvl(l_ctr,0)=0

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 1567: AHL_OPERATION_RESOURCES AOPR,AHL_DEPARTMENT_SHIFTS ADS, mtl_employees_current_view PEPF, BOM_RESOURCES BOMR, MFG_LOOKUPS MFGL

1563: AWOS.DEPARTMENT_NAME,
1564: AWOS.DEPARTMENT_ID,
1565: AWOS.ITEM_INSTANCE_ID
1566: FROM AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDER_TASKS_V AWOS, AHL_WORKORDER_OPERATIONS AWOP,
1567: AHL_OPERATION_RESOURCES AOPR,AHL_DEPARTMENT_SHIFTS ADS, mtl_employees_current_view PEPF, BOM_RESOURCES BOMR, MFG_LOOKUPS MFGL
1568: WHERE AWAS.OPERATION_RESOURCE_ID = AOPR.OPERATION_RESOURCE_ID
1569: AND AWOP.WORKORDER_OPERATION_ID = AOPR.WORKORDER_OPERATION_ID
1570: AND AWOP.WORKORDER_ID = AWOS.WORKORDER_ID
1571: AND AWOS.DEPARTMENT_ID = ADS.DEPARTMENT_ID (+)