[Home] [Help]
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
78: AND WRS.ORGANIZATION_ID = WO.ORGANIZATION_ID
606: msi.buyer_id,
607: x_project_id,
608: x_task_id,
609: DECODE(x_project_id,NULL,NULL,'Y')
610: FROM WIP_REPETITIVE_SCHEDULES wrs,
611: HR_ORGANIZATION_INFORMATION hoi,
612: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2,-- Bug 4398047 removed bcd1 and bcd2
613: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
614: FND_USER fu, BOM_DEPARTMENTS bd,
799: msi.buyer_id,
800: x_project_id,
801: x_task_id,
802: DECODE(x_project_id,NULL,NULL,'Y')
803: FROM WIP_REPETITIVE_SCHEDULES wrs, /*MTL_ITEM_REVISIONS mir, */
804: HR_ORGANIZATION_INFORMATION hoi,
805: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2, -- Bug 4398047 Commented out bcd1 and bcd2
806: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
807: FND_USER fu, BOM_DEPARTMENTS bd,
1302: OR
1303: (c_entity_type = WIP_CONSTANTS.REPETITIVE AND
1304: wor.repetitive_schedule_id IN
1305: (SELECT wrs.repetitive_schedule_id
1306: FROM wip_repetitive_schedules wrs
1307: WHERE wrs.wip_entity_id = c_wip_entity_id
1308: AND wrs.organization_id = c_org_id
1309: AND wrs.line_id = c_line_id
1310: AND wrs.status_type in (WIP_CONSTANTS.RELEASED,
1352: OR
1353: (c_entity_type = WIP_CONSTANTS.REPETITIVE AND
1354: wor.repetitive_schedule_id IN
1355: (SELECT repetitive_schedule_id
1356: FROM wip_repetitive_schedules wrs
1357: WHERE wrs.organization_id = c_org_id
1358: AND wrs.wip_entity_id = c_wip_entity_id
1359: AND wrs.line_id = c_line_id
1360: AND wrs.status_type IN (WIP_CONSTANTS.RELEASED,
1416: AND p_entity_type <> WIP_CONSTANTS.REPETITIVE
1417: UNION ALL
1418: SELECT wrs.wip_entity_id job_id,
1419: wrs.repetitive_schedule_id rep_schedule_id
1420: FROM wip_repetitive_schedules wrs
1421: WHERE wrs.status_type IN (WIP_CONSTANTS.RELEASED,
1422: WIP_CONSTANTS.UNRELEASED,
1423: WIP_CONSTANTS.HOLD)
1424: AND wrs.organization_id = p_org_id
1829: po_headers_all ph,
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
1875: UNION ALL
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)
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
1963: AND pd.line_location_id = pll.line_location_id
1964: AND pd.po_line_id = pl.po_line_id
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
2040: pll.po_release_id together to prevent the cursor to pick all release
2041: document
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'
2107: FROM po_line_locations_all pll
2108: WHERE prl.line_location_id = pll.line_location_id)
2192: ELSE
2193: -- Repetitive schedules
2194: SELECT po_creation_time
2195: INTO l_po_creation_time
2196: FROM wip_repetitive_schedules
2197: WHERE repetitive_schedule_id = p_repetitive_id
2198: AND organization_id = p_org_id;
2199: END IF;
2200: