[Home] [Help]
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
54: AND WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
459: and wo.organization_id = P_Organization_Id;
460:
461: CURSOR Cproject IS
462: SELECT project_id , task_id
463: FROM WIP_DISCRETE_JOBS
464: WHERE organization_id = P_Organization_Id
465: AND wip_entity_id = P_Wip_Entity_Id;
466:
467: BEGIN
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
622: AND decode(nvl(P_Resource_Seq_Num, -1),
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
815: AND decode(nvl(P_Resource_Seq_Num, -1),
1405: p_entity_type IN NUMBER) IS
1406: CURSOR c_job_schedule IS
1407: SELECT wdj.wip_entity_id job_id,
1408: to_number(null) rep_schedule_id
1409: FROM wip_discrete_jobs wdj
1410: WHERE wdj.status_type IN (WIP_CONSTANTS.RELEASED,
1411: WIP_CONSTANTS.UNRELEASED,
1412: WIP_CONSTANTS.HOLD)
1413: AND (p_project_id IS NULL OR wdj.project_id = p_project_id)
1828: po_lines_all pl,
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
1874: HAVING count(*) > 1
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
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
1963: AND pd.line_location_id = pll.line_location_id
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
2040: pll.po_release_id together to prevent the cursor to pick all release
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'
2107: FROM po_line_locations_all pll
2185: IF(p_repetitive_id IS NULL) THEN
2186: -- Discrete jobs
2187: SELECT po_creation_time
2188: INTO l_po_creation_time
2189: FROM wip_discrete_jobs
2190: WHERE wip_entity_id = p_job_id
2191: AND organization_id = p_org_id;
2192: ELSE
2193: -- Repetitive schedules