[Home] [Help]
45: decode (WO.PREVIOUS_OPERATION_SEQ_NUM, NULL, 'YES', 'NO') FIRST_OP,
46: WO.SCHEDULED_QUANTITY,
47: WE.ENTITY_TYPE
48: FROM WIP_OPERATION_RESOURCES WOR,
49: WIP_OPERATIONS WO,
50: WIP_DISCRETE_JOBS WDJ,
51: WIP_ENTITIES WE
52: WHERE WO.WIP_ENTITY_ID = P_Wip_Entity_Id
53: AND WO.ORGANIZATION_ID = P_Organization_Id
69: WO.COUNT_POINT_TYPE, WOR.AUTOCHARGE_TYPE,
70: decode (WO.PREVIOUS_OPERATION_SEQ_NUM, NULL, 'YES', 'NO') FIRST_OP,
71: WO.SCHEDULED_QUANTITY
72: FROM WIP_OPERATION_RESOURCES WOR,
73: WIP_OPERATIONS WO,
74: WIP_REPETITIVE_SCHEDULES WRS
75: WHERE WO.WIP_ENTITY_ID = P_Wip_Entity_Id
76: AND WO.ORGANIZATION_ID = P_Organization_Id
77: AND WO.REPETITIVE_SCHEDULE_ID = P_Repetitive_Schedule_Id
182: p_primary_uom => l_primary_uom,
183: p_op_seq_num => cdis_rec.OPERATION_SEQ_NUM );
184:
185: if l_itemkey is not null then
186: update wip_operations
187: set wf_itemtype = 'WIPISHPW',
188: wf_itemkey = l_itemkey
189: where wip_entity_id = P_Wip_Entity_Id
190: and organization_id = P_Organization_Id
302: p_primary_uom => l_primary_uom,
303: p_op_seq_num => crep_rec.OPERATION_SEQ_NUM );
304:
305: if l_itemkey is not null then
306: update wip_operations
307: set wf_itemtype = 'WIPISHPW',
308: wf_itemkey = l_itemkey
309: where wip_entity_id = P_Wip_Entity_Id
310: and repetitive_schedule_id = P_Repetitive_Schedule_Id
437:
438: -- If this cursor returns a row, we have an error condition.
439: CURSOR Cops IS
440: select 'X'
441: from wip_operations wo,bom_departments bd
442: where wo.department_id = bd.department_id
443: and wo.organization_id = bd.organization_id
444: and bd.location_id IS NULL
445: and level < 3
613: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
614: FND_USER fu, BOM_DEPARTMENTS bd,
615: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
616: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
617: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
618: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
619: WHERE op1.organization_id = wor.organization_id
620: AND op1.wip_entity_id = wor.wip_entity_id
621: AND op1.operation_seq_num = wor.operation_seq_num
806: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
807: FND_USER fu, BOM_DEPARTMENTS bd,
808: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
809: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
810: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
811: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
812: WHERE op1.organization_id = wor.organization_id
813: AND op1.wip_entity_id = wor.wip_entity_id
814: AND op1.operation_seq_num = wor.operation_seq_num
1289: -- has a location set up
1290: SELECT 'WIP_PO_MOVE_LOCATION' error_message
1291: FROM bom_departments bd,
1292: wip_operation_resources wor,
1293: wip_operations wo1,
1294: wip_operations wo2
1295: WHERE wor.organization_id = c_org_id
1296: AND wor.wip_entity_id = c_wip_entity_id
1297: AND wor.operation_seq_num = c_to_op
1290: SELECT 'WIP_PO_MOVE_LOCATION' error_message
1291: FROM bom_departments bd,
1292: wip_operation_resources wor,
1293: wip_operations wo1,
1294: wip_operations wo2
1295: WHERE wor.organization_id = c_org_id
1296: AND wor.wip_entity_id = c_wip_entity_id
1297: AND wor.operation_seq_num = c_to_op
1298: AND c_fm_op < c_to_op
1545: FROM bom_calendar_dates bcd1,
1546: bom_calendar_dates bcd2,
1547: mtl_system_items msi,
1548: mtl_parameters mp,
1549: wip_operations wo1,
1550: wip_operations wo2
1551: WHERE mp.organization_id = p_org_id
1552: AND mp.organization_id = msi.organization_id
1553: AND msi.inventory_item_id = p_item_id
1546: bom_calendar_dates bcd2,
1547: mtl_system_items msi,
1548: mtl_parameters mp,
1549: wip_operations wo1,
1550: wip_operations wo2
1551: WHERE mp.organization_id = p_org_id
1552: AND mp.organization_id = msi.organization_id
1553: AND msi.inventory_item_id = p_item_id
1554: AND wo1.organization_id = mp.organization_id
1830: po_releases_all pr,
1831: po_line_locations_all pll,
1832: wip_discrete_jobs wdj, -- bugfix 5000087
1833: wip_repetitive_schedules wrs, -- bugfix 5000087
1834: wip_operations wo -- bugfix 5000087
1835: WHERE pd.po_line_id = pl.po_line_id
1836: AND ph.po_header_id = pd.po_header_id
1837: AND pd.line_location_id = pll.line_location_id
1838: AND pd.po_release_id = pr.po_release_id (+)
1876: SELECT count(*)
1877: FROM po_requisition_lines_all prl,
1878: wip_discrete_jobs wdj, -- bugfix 5000087
1879: wip_repetitive_schedules wrs, -- bugfix 5000087
1880: wip_operations wo -- bugfix 5000087
1881: WHERE prl.wip_entity_id = p_job_id
1882: AND (p_repetitive_id IS NULL OR
1883: prl.wip_repetitive_schedule_id = p_repetitive_id)
1884: AND prl.destination_organization_id = p_org_id
1954: po_headers_all ph,
1955: po_lines_all pl,
1956: po_line_locations_all pll,
1957: wip_operation_resources wor,
1958: wip_operations wo,
1959: wip_discrete_jobs wdj,
1960: wip_repetitive_schedules wrs
1961: WHERE ph.type_lookup_code = 'STANDARD'
1962: AND ph.po_header_id = pd.po_header_id
2031: po_lines_all pl,
2032: po_line_locations_all pll,
2033: po_releases_all pr,
2034: wip_operation_resources wor,
2035: wip_operations wo,
2036: wip_discrete_jobs wdj,
2037: wip_repetitive_schedules wrs
2038: WHERE ph.type_lookup_code = 'BLANKET'
2039: /* Fixed bug 4240329. Add condition below to join pr.po_release_id and
2098: FROM mtl_system_items msi,
2099: po_requisition_headers_all prh,
2100: po_requisition_lines_all prl,
2101: wip_operation_resources wor,
2102: wip_operations wo,
2103: wip_discrete_jobs wdj,
2104: wip_repetitive_schedules wrs
2105: WHERE NOT EXISTS
2106: (SELECT 'x'
2790: select count(1)
2791: into l_count
2792: from
2793: wip_operation_resources wor,
2794: wip_operations wo,
2795: bom_departments bd
2796: where
2797: wor.wip_entity_id = wo.wip_entity_id
2798: and wor.organization_id = wo.organization_id
2806: and nvl(wo.repetitive_schedule_id,-1) = nvl(p_repetitive_id,-1)
2807: and ((wo.operation_seq_num = p_op_seq_num
2808: and wor.resource_seq_num > p_res_seq_num) or
2809: (wo.operation_seq_num = (select next_operation_seq_num
2810: from wip_operations
2811: where wip_entity_id = p_wip_entity_id
2812: and operation_seq_num = p_op_seq_num)))
2813: and rownum = 1;
2814: return l_count;