APPS.AHL_PRD_RESOURCE_TRANX_PVT dependencies on AHL_WORKORDER_OPERATIONS

Line 38: AHL_WORKORDER_OPERATIONS awop,

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

Line 285: from AHL_WORKORDER_OPERATIONS A

281: FND_MSG_PUB.ADD;
282: Else
283: --Select count(*) into l_ctr
284: Select 1 into l_ctr
285: from AHL_WORKORDER_OPERATIONS A
286: WHERE A.WORKORDER_ID=p_prd_resrc_txn_tbl(I).workorder_id
287: AND A.OPERATION_SEQUENCE_NUM=p_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM;
288:
289: IF nvl(l_ctr,0)=0

Line 584: from ahl_workorder_operations_v

580: Cursor CurGetOperSeq(c_Oper_seq number,c_work_id number)
581: Is
582: /*
583: Select workorder_operation_id, department_id, department_code
584: from ahl_workorder_operations_v
585: where operation_sequence_num=c_oper_seq
586: and workorder_id=c_work_id;
587: */
588:

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 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 1504: FROM AHL_WORKORDER_OPERATIONS_V

1500:
1501: cursor get_operation_rec(c_operation_id NUMBER)
1502: is
1503: SELECT *
1504: FROM AHL_WORKORDER_OPERATIONS_V
1505: WHERE workorder_operation_id=c_operation_id;
1506:
1507: l_operation_rec get_operation_rec%ROWTYPE;
1508:

Line 1608: FROM AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDER_TASKS_V AWOS, AHL_WORKORDER_OPERATIONS AWOP,

1604: PEPF.FULL_NAME ,
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