APPS.AHL_PRD_RESOURCE_TRANX_PVT dependencies on AHL_WORKORDERS

Line 16: from AHL_WORKORDERS

12: l_ctr NUMBER:=0;
13: Cursor ValidWrkDet(C_WORKORDER_ID NUMBER)
14: Is
15: Select wip_entity_id, workorder_name, status_code
16: from AHL_WORKORDERS
17: Where Workorder_id=C_WORKORDER_ID;
18:
19: l_wrkrec ValidWrkDet%rowtype;
20:

Line 150: from ahl_workorders wo,

146: /*
147: Cursor get_wo_org_id(c_wo_id number)
148: Is
149: Select vst.organization_id
150: from ahl_workorders wo,
151: ahl_visits_b vst
152: where vst.visit_id = wo.visit_id
153: and wo.workorder_id = c_wo_id;
154: */

Line 694: from ahl_workorders wo,

690:
691: Cursor get_wo_org_id(c_wo_id number)
692: Is
693: Select vst.organization_id
694: from ahl_workorders wo,
695: ahl_visits_b vst
696: where vst.visit_id = wo.visit_id
697: and wo.workorder_id = c_wo_id;
698:

Line 1008: from ahl_workorders

1004:
1005: Cursor GetWipid (C_WORK_ID Number)
1006: Is
1007: Select wip_entity_id
1008: from ahl_workorders
1009: where workorder_id=c_work_id;
1010:
1011: Cursor get_oper_res_det(p_workorder_id IN NUMBER,
1012: p_operation_seq_num IN NUMBER)

Line 1018: From WIP_OPERATIONS WOP, AHL_WORKORDERS AW

1014: Select WOP.FIRST_UNIT_START_DATE, WOP.LAST_UNIT_COMPLETION_DATE,
1015: (select nvl(max(resource_seq_num),0) + 10 from wip_operation_resources
1016: where wip_entity_id = WOP.wip_entity_id and operation_seq_num = WOP.operation_seq_num),
1017: WOP.Department_id
1018: From WIP_OPERATIONS WOP, AHL_WORKORDERS AW
1019: Where AW.wip_entity_id = WOP.wip_entity_id
1020: and AW.workorder_id = p_workorder_id
1021: and WOP.operation_seq_num = p_operation_seq_num;
1022:

Line 1365: FROM AHL_WORKORDERS

1361:
1362: CURSOR get_wo_details(c_workorder_id NUMBER)
1363: IS
1364: SELECT workorder_name
1365: FROM AHL_WORKORDERS
1366: WHERE WORKORDER_ID = c_workorder_id;
1367:
1368: BEGIN
1369:

Line 1535: from ahl_workorders

1531:
1532: Cursor GetWipid (C_WORK_ID Number)
1533: Is
1534: Select wip_entity_id, status_code
1535: from ahl_workorders
1536: where workorder_id=c_work_id;
1537:
1538:
1539: CURSOR getDefaultUOM