[Home] [Help]
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
50: AND WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
424: and wo.organization_id = P_Organization_Id;
425:
426: CURSOR Cproject IS
427: SELECT project_id , task_id
428: FROM WIP_DISCRETE_JOBS
429: WHERE organization_id = P_Organization_Id
430: AND wip_entity_id = P_Wip_Entity_Id;
431:
432: BEGIN
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
574: AND decode(nvl(P_Resource_Seq_Num, -1),
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
758: AND decode(nvl(P_Resource_Seq_Num, -1),
1319: p_entity_type IN NUMBER) IS
1320: CURSOR c_job_schedule IS
1321: SELECT wdj.wip_entity_id job_id,
1322: to_number(null) rep_schedule_id
1323: FROM wip_discrete_jobs wdj
1324: WHERE wdj.status_type IN (WIP_CONSTANTS.RELEASED,
1325: WIP_CONSTANTS.UNRELEASED,
1326: WIP_CONSTANTS.HOLD)
1327: AND (p_project_id IS NULL OR wdj.project_id = p_project_id)
1735: po_lines_all pl,
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
1781: HAVING count(*) > 1
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
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
1855: AND pd.line_location_id = pll.line_location_id
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
1919: pll.po_release_id together to prevent the cursor to pick all release
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'
1986: FROM po_line_locations_all pll
2059: IF(p_repetitive_id IS NULL) THEN
2060: -- Discrete jobs
2061: SELECT po_creation_time
2062: INTO l_po_creation_time
2063: FROM wip_discrete_jobs
2064: WHERE wip_entity_id = p_job_id
2065: AND organization_id = p_org_id;
2066: ELSE
2067: -- Repetitive schedules