[Home] [Help]
41: decode (WO.PREVIOUS_OPERATION_SEQ_NUM, NULL, 'YES', 'NO') FIRST_OP,
42: WO.SCHEDULED_QUANTITY,
43: WE.ENTITY_TYPE
44: FROM WIP_OPERATION_RESOURCES WOR,
45: WIP_OPERATIONS WO,
46: WIP_DISCRETE_JOBS WDJ,
47: WIP_ENTITIES WE
48: WHERE WO.WIP_ENTITY_ID = P_Wip_Entity_Id
49: AND WO.ORGANIZATION_ID = P_Organization_Id
65: WO.COUNT_POINT_TYPE, WOR.AUTOCHARGE_TYPE,
66: decode (WO.PREVIOUS_OPERATION_SEQ_NUM, NULL, 'YES', 'NO') FIRST_OP,
67: WO.SCHEDULED_QUANTITY
68: FROM WIP_OPERATION_RESOURCES WOR,
69: WIP_OPERATIONS WO,
70: WIP_REPETITIVE_SCHEDULES WRS
71: WHERE WO.WIP_ENTITY_ID = P_Wip_Entity_Id
72: AND WO.ORGANIZATION_ID = P_Organization_Id
73: AND WO.REPETITIVE_SCHEDULE_ID = P_Repetitive_Schedule_Id
170: p_primary_uom => l_primary_uom,
171: p_op_seq_num => cdis_rec.OPERATION_SEQ_NUM );
172:
173: if l_itemkey is not null then
174: update wip_operations
175: set wf_itemtype = 'WIPISHPW',
176: wf_itemkey = l_itemkey
177: where wip_entity_id = P_Wip_Entity_Id
178: and organization_id = P_Organization_Id
289: p_primary_uom => l_primary_uom,
290: p_op_seq_num => crep_rec.OPERATION_SEQ_NUM );
291:
292: if l_itemkey is not null then
293: update wip_operations
294: set wf_itemtype = 'WIPISHPW',
295: wf_itemkey = l_itemkey
296: where wip_entity_id = P_Wip_Entity_Id
297: and repetitive_schedule_id = P_Repetitive_Schedule_Id
402:
403: -- If this cursor returns a row, we have an error condition.
404: CURSOR Cops IS
405: select 'X'
406: from wip_operations wo,bom_departments bd
407: where wo.department_id = bd.department_id
408: and wo.organization_id = bd.organization_id
409: and bd.location_id IS NULL
410: and level < 3
565: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
566: FND_USER fu, BOM_DEPARTMENTS bd,
567: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
568: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
569: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
570: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
571: WHERE op1.organization_id = wor.organization_id
572: AND op1.wip_entity_id = wor.wip_entity_id
573: AND op1.operation_seq_num = wor.operation_seq_num
749: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
750: FND_USER fu, BOM_DEPARTMENTS bd,
751: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
752: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
753: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
754: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
755: WHERE op1.organization_id = wor.organization_id
756: AND op1.wip_entity_id = wor.wip_entity_id
757: AND op1.operation_seq_num = wor.operation_seq_num
1203: -- has a location set up
1204: SELECT 'WIP_PO_MOVE_LOCATION' error_message
1205: FROM bom_departments bd,
1206: wip_operation_resources wor,
1207: wip_operations wo1,
1208: wip_operations wo2
1209: WHERE wor.organization_id = c_org_id
1210: AND wor.wip_entity_id = c_wip_entity_id
1211: AND wor.operation_seq_num = c_to_op
1204: SELECT 'WIP_PO_MOVE_LOCATION' error_message
1205: FROM bom_departments bd,
1206: wip_operation_resources wor,
1207: wip_operations wo1,
1208: wip_operations wo2
1209: WHERE wor.organization_id = c_org_id
1210: AND wor.wip_entity_id = c_wip_entity_id
1211: AND wor.operation_seq_num = c_to_op
1212: AND c_fm_op < c_to_op
1452: FROM bom_calendar_dates bcd1,
1453: bom_calendar_dates bcd2,
1454: mtl_system_items msi,
1455: mtl_parameters mp,
1456: wip_operations wo1,
1457: wip_operations wo2
1458: WHERE mp.organization_id = p_org_id
1459: AND mp.organization_id = msi.organization_id
1460: AND msi.inventory_item_id = p_item_id
1453: bom_calendar_dates bcd2,
1454: mtl_system_items msi,
1455: mtl_parameters mp,
1456: wip_operations wo1,
1457: wip_operations wo2
1458: WHERE mp.organization_id = p_org_id
1459: AND mp.organization_id = msi.organization_id
1460: AND msi.inventory_item_id = p_item_id
1461: AND wo1.organization_id = mp.organization_id
1737: po_releases_all pr,
1738: po_line_locations_all pll,
1739: wip_discrete_jobs wdj, -- bugfix 5000087
1740: wip_repetitive_schedules wrs, -- bugfix 5000087
1741: wip_operations wo -- bugfix 5000087
1742: WHERE pd.po_line_id = pl.po_line_id
1743: AND ph.po_header_id = pd.po_header_id
1744: AND pd.line_location_id = pll.line_location_id
1745: AND pd.po_release_id = pr.po_release_id (+)
1783: SELECT count(*)
1784: FROM po_requisition_lines_all prl,
1785: wip_discrete_jobs wdj, -- bugfix 5000087
1786: wip_repetitive_schedules wrs, -- bugfix 5000087
1787: wip_operations wo -- bugfix 5000087
1788: WHERE prl.wip_entity_id = p_job_id
1789: AND (p_repetitive_id IS NULL OR
1790: prl.wip_repetitive_schedule_id = p_repetitive_id)
1791: AND prl.destination_organization_id = p_org_id
1846: po_headers_all ph,
1847: po_lines_all pl,
1848: po_line_locations_all pll,
1849: wip_operation_resources wor,
1850: wip_operations wo,
1851: wip_discrete_jobs wdj,
1852: wip_repetitive_schedules wrs
1853: WHERE ph.type_lookup_code = 'STANDARD'
1854: AND ph.po_header_id = pd.po_header_id
1910: po_lines_all pl,
1911: po_line_locations_all pll,
1912: po_releases_all pr,
1913: wip_operation_resources wor,
1914: wip_operations wo,
1915: wip_discrete_jobs wdj,
1916: wip_repetitive_schedules wrs
1917: WHERE ph.type_lookup_code = 'BLANKET'
1918: /* Fixed bug 4240329. Add condition below to join pr.po_release_id and
1977: FROM mtl_system_items msi,
1978: po_requisition_headers_all prh,
1979: po_requisition_lines_all prl,
1980: wip_operation_resources wor,
1981: wip_operations wo,
1982: wip_discrete_jobs wdj,
1983: wip_repetitive_schedules wrs
1984: WHERE NOT EXISTS
1985: (SELECT 'x'