[Home] [Help]
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
74: AND WRS.ORGANIZATION_ID = WO.ORGANIZATION_ID
558: msi.buyer_id,
559: x_project_id,
560: x_task_id,
561: DECODE(x_project_id,NULL,NULL,'Y')
562: FROM WIP_REPETITIVE_SCHEDULES wrs,
563: HR_ORGANIZATION_INFORMATION hoi,
564: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2,-- Bug 4398047 removed bcd1 and bcd2
565: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
566: FND_USER fu, BOM_DEPARTMENTS bd,
742: msi.buyer_id,
743: x_project_id,
744: x_task_id,
745: DECODE(x_project_id,NULL,NULL,'Y')
746: FROM WIP_REPETITIVE_SCHEDULES wrs, /*MTL_ITEM_REVISIONS mir, */
747: HR_ORGANIZATION_INFORMATION hoi,
748: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2, -- Bug 4398047 Commented out bcd1 and bcd2
749: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
750: FND_USER fu, BOM_DEPARTMENTS bd,
1216: OR
1217: (c_entity_type = WIP_CONSTANTS.REPETITIVE AND
1218: wor.repetitive_schedule_id IN
1219: (SELECT wrs.repetitive_schedule_id
1220: FROM wip_repetitive_schedules wrs
1221: WHERE wrs.wip_entity_id = c_wip_entity_id
1222: AND wrs.organization_id = c_org_id
1223: AND wrs.line_id = c_line_id
1224: AND wrs.status_type in (WIP_CONSTANTS.RELEASED,
1266: OR
1267: (c_entity_type = WIP_CONSTANTS.REPETITIVE AND
1268: wor.repetitive_schedule_id IN
1269: (SELECT repetitive_schedule_id
1270: FROM wip_repetitive_schedules wrs
1271: WHERE wrs.organization_id = c_org_id
1272: AND wrs.wip_entity_id = c_wip_entity_id
1273: AND wrs.line_id = c_line_id
1274: AND wrs.status_type IN (WIP_CONSTANTS.RELEASED,
1330: AND p_entity_type <> WIP_CONSTANTS.REPETITIVE
1331: UNION ALL
1332: SELECT wrs.wip_entity_id job_id,
1333: wrs.repetitive_schedule_id rep_schedule_id
1334: FROM wip_repetitive_schedules wrs
1335: WHERE wrs.status_type IN (WIP_CONSTANTS.RELEASED,
1336: WIP_CONSTANTS.UNRELEASED,
1337: WIP_CONSTANTS.HOLD)
1338: AND wrs.organization_id = p_org_id
1736: po_headers_all ph,
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
1782: UNION ALL
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)
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
1855: AND pd.line_location_id = pll.line_location_id
1856: AND pd.po_line_id = pl.po_line_id
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
1919: pll.po_release_id together to prevent the cursor to pick all release
1920: document
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'
1986: FROM po_line_locations_all pll
1987: WHERE prl.line_location_id = pll.line_location_id)
2066: ELSE
2067: -- Repetitive schedules
2068: SELECT po_creation_time
2069: INTO l_po_creation_time
2070: FROM wip_repetitive_schedules
2071: WHERE repetitive_schedule_id = p_repetitive_id
2072: AND organization_id = p_org_id;
2073: END IF;
2074: