[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DISTINCT p.project_id,
p.project_number,
p.project_name
FROM po_distributions_all pod,
pjm_projects_mtll_v p
WHERE pod.project_id = p.project_id
AND pod.po_header_id = p_po_header_id
AND pod.po_line_id = NVL ( p_po_line_id, pod.po_line_id )
AND Nvl(pod.po_release_id,-999) = Nvl(p_po_release_id, Nvl(pod.po_release_id, -999))
AND ( p_item_id IS NULL
OR pod.po_line_id IN (
SELECT pol.po_line_id
FROM po_lines_all pol
WHERE pol.item_id = p_item_id
AND pol.po_header_id = p_po_header_id
)
)
AND p.project_number LIKE ( p_project_number )
AND pod.project_id IS NOT NULL ;
SELECT DISTINCT p.project_id,
p.project_number,
p.project_name
FROM po_distributions_all pod,
pjm_projects_mtll_v p
WHERE pod.project_id = p.project_id
AND pod.po_header_id = p_po_header_id
AND pod.po_line_id = NVL ( p_po_line_id, pod.po_line_id )
AND Nvl(pod.po_release_id,-999) = Nvl(p_po_release_id, Nvl(pod.po_release_id, -999))
AND ( p_item_id IS NULL
OR pod.po_line_id IN (
SELECT pol.po_line_id
FROM po_lines_all pol
WHERE pol.item_id = p_item_id
AND pol.po_header_id = p_po_header_id
)
)
AND p.project_number LIKE ( p_project_number )
AND pod.project_id IS NOT NULL
UNION ALL
SELECT DISTINCT -9999 project_id,
l_no_proj_str project_number,
l_no_proj_str project_name
FROM po_distributions_all pod
WHERE pod.project_id is NULL
AND pod.po_header_id = p_po_header_id
AND pod.po_line_id = NVL (p_po_line_id ,POD.PO_LINE_ID )
AND Nvl(pod.po_release_id,-999) = Nvl(p_po_release_id, Nvl(pod.po_release_id, -999))
AND (p_item_id IS NULL OR pod.po_line_id IN ( SELECT pol.po_line_id
FROM po_lines_all pol
WHERE pol.item_id = p_item_id
AND pol.po_header_id=p_po_header_id)
)
AND l_no_proj_str LIKE ( p_project_number ) ;
SELECT DISTINCT p.project_id,
p.project_number,
p.project_name
FROM po_distributions_all pod,
pjm_projects_mtll_v p,
po_line_locations_all poll
WHERE pod.project_id = p.project_id
AND pod.po_header_id = p_po_header_id
AND pod.po_line_id = NVL ( p_po_line_id, pod.po_line_id )
AND Nvl(pod.po_release_id,-999) = Nvl(p_po_release_id, Nvl(pod.po_release_id, -999))
AND ( p_item_id IS NULL
OR pod.po_line_id IN (
SELECT pol.po_line_id
FROM po_lines pol
WHERE pol.item_id = p_item_id
AND pol.po_header_id = p_po_header_id
)
)
AND pod.line_location_id = poll.line_location_id
AND pod.po_line_id = poll.po_line_id
AND Nvl(pod.po_release_id,-999) = Nvl(poll.po_release_id,-999)
AND pod.po_header_id = poll.po_header_id
AND Nvl(poll.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
AND poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
AND NVL(poll.APPROVED_FLAG,'N') = 'Y'
AND NVL(poll.CANCEL_FLAG, 'N') = 'N'
AND p.project_number LIKE ( p_project_number )
AND pod.project_id IS NOT NULL ;
SELECT DISTINCT p.project_id,
p.project_number,
p.project_name
FROM po_distributions_all pod,
pjm_projects_mtll_v p,
po_line_locations_all poll
WHERE pod.project_id = p.project_id
AND pod.po_header_id = p_po_header_id
AND pod.po_line_id = NVL ( p_po_line_id, pod.po_line_id )
AND Nvl(pod.po_release_id,-999) = Nvl(p_po_release_id, Nvl(pod.po_release_id, -999))
AND ( p_item_id IS NULL
OR pod.po_line_id IN (
SELECT pol.po_line_id
FROM po_lines_all pol /* bug 6785303 po_lines -> po_lines_all */
WHERE pol.item_id = p_item_id
AND pol.po_header_id = p_po_header_id
)
)
AND pod.line_location_id = poll.line_location_id
AND pod.po_line_id = poll.po_line_id
AND Nvl(pod.po_release_id,-999) = Nvl(poll.po_release_id,-999)
AND pod.po_header_id = poll.po_header_id
AND Nvl(poll.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
AND poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
AND NVL(poll.APPROVED_FLAG,'N') = 'Y'
AND NVL(poll.CANCEL_FLAG, 'N') = 'N'
AND p.project_number LIKE ( p_project_number )
AND pod.project_id IS NOT NULL
UNION ALL
SELECT DISTINCT -9999 project_id,
l_no_proj_str project_number,
l_no_proj_str project_name
FROM po_distributions_all pod,
po_line_locations_all poll
WHERE pod.project_id is NULL
AND pod.po_header_id = p_po_header_id
AND pod.po_line_id = NVL (p_po_line_id ,POD.PO_LINE_ID )
AND Nvl(pod.po_release_id,-999) = Nvl(p_po_release_id, Nvl(pod.po_release_id, -999))
AND (p_item_id IS NULL OR pod.po_line_id IN ( SELECT pol.po_line_id
FROM po_lines pol
WHERE pol.item_id = p_item_id
AND pol.po_header_id=p_po_header_id)
)
AND pod.line_location_id = poll.line_location_id
AND pod.po_line_id = poll.po_line_id
AND Nvl(pod.po_release_id,-999) = Nvl(poll.po_release_id,-999)
AND pod.po_header_id = poll.po_header_id
AND Nvl(poll.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
AND poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
AND NVL(poll.APPROVED_FLAG,'N') = 'Y'
AND NVL(poll.CANCEL_FLAG, 'N') = 'N'
AND l_no_proj_str LIKE ( p_project_number ) ;
SELECT DISTINCT p.project_id,
p.project_number,
p.project_name
FROM po_distributions_all pod,
pjm_projects_mtll_v p,
rcv_shipment_lines rsl
WHERE pod.project_id IS NOT NULL
AND pod.po_header_id = rsl.po_header_id
AND pod.project_id = p.project_id
AND pod.po_header_id = NVL ( p_po_header_id, pod.po_header_id )
AND p.project_number LIKE ( p_project_number )
AND rsl.shipment_header_id = p_shipment_header_id
AND ( (p_lpn_id IS NULL) OR
(p_lpn_id IS NOT NULL AND EXISTS
( SELECT wlc.inventory_item_id
FROM wms_lpn_contents wlc
WHERE wlc.inventory_item_id = rsl.item_id
AND wlc.parent_lpn_id IN
( SELECT lpn_id
FROM wms_license_plate_numbers
START WITH lpn_id = p_lpn_id
CONNECT BY parent_lpn_id = PRIOR lpn_id
)
)
)
);
SELECT DISTINCT p.project_id,
p.project_number,
p.project_name
FROM po_distributions_all pod,
pjm_projects_mtll_v p,
rcv_shipment_lines rsl
WHERE pod.project_id IS NOT NULL
AND pod.po_header_id = rsl.po_header_id
AND pod.project_id = p.project_id
AND pod.po_header_id = NVL ( p_po_header_id, pod.po_header_id )
AND p.project_number LIKE ( p_project_number )
AND rsl.shipment_header_id = p_shipment_header_id
AND ( (p_lpn_id IS NULL) OR
(p_lpn_id IS NOT NULL AND EXISTS
( SELECT wlc.inventory_item_id
FROM wms_lpn_contents wlc
WHERE wlc.inventory_item_id = rsl.item_id
AND wlc.parent_lpn_id IN
( SELECT lpn_id
FROM wms_license_plate_numbers
START WITH lpn_id = p_lpn_id
CONNECT BY parent_lpn_id = PRIOR lpn_id
)
)
)
)
UNION ALL
SELECT DISTINCT -9999 project_id,
l_no_proj_str project_number,
l_no_proj_str project_name
FROM po_distributions_all pod,
rcv_shipment_lines rsl
WHERE pod.project_id IS NULL
AND pod.po_header_id = rsl.po_header_id
AND pod.po_header_id = NVL ( p_po_header_id, pod.po_header_id )
AND l_no_proj_str LIKE ( p_project_number )
AND rsl.shipment_header_id = p_shipment_header_id
AND ( (p_lpn_id IS NULL) OR
(p_lpn_id IS NOT NULL AND EXISTS
( SELECT wlc.inventory_item_id
FROM wms_lpn_contents wlc
WHERE wlc.inventory_item_id = rsl.item_id
AND wlc.parent_lpn_id IN
( SELECT lpn_id
FROM wms_license_plate_numbers
START WITH lpn_id = p_lpn_id
CONNECT BY parent_lpn_id = PRIOR lpn_id
)
)
)
);
SELECT DISTINCT p.project_id,
p.project_number,
p.project_name
FROM po_req_distributions_all prd,
pjm_projects_mtll_v p,
po_requisition_lines_all prl
WHERE prd.project_id IS NOT NULL
AND prd.project_id = p.project_id
AND prd.requisition_line_id = prl.requisition_line_id
AND prl.requisition_header_id = p_req_header_id
AND p.project_number LIKE p_project_number
AND ( p_item_id IS NULL
OR prl.item_id = p_item_id )
AND ( (p_lpn_id IS NULL) OR
(p_lpn_id IS NOT NULL AND EXISTS
( SELECT wlc.inventory_item_id
FROM wms_lpn_contents wlc
WHERE wlc.inventory_item_id = prl.item_id
AND wlc.parent_lpn_id IN
( SELECT lpn_id
FROM wms_license_plate_numbers
START WITH lpn_id = p_lpn_id
CONNECT BY parent_lpn_id = PRIOR lpn_id
)
)
)
);
SELECT DISTINCT p.project_id,
p.project_number,
p.project_name
FROM po_req_distributions_all prd,
pjm_projects_mtll_v p,
po_requisition_lines_all prl
WHERE prd.project_id IS NOT NULL
AND prd.project_id = p.project_id
AND prd.requisition_line_id = prl.requisition_line_id
AND prl.requisition_header_id = p_req_header_id
AND p.project_number LIKE p_project_number
AND ( p_item_id IS NULL
OR prl.item_id = p_item_id )
AND ( (p_lpn_id IS NULL) OR
(p_lpn_id IS NOT NULL AND EXISTS
( SELECT wlc.inventory_item_id
FROM wms_lpn_contents wlc
WHERE wlc.inventory_item_id = prl.item_id
AND wlc.parent_lpn_id IN
( SELECT lpn_id
FROM wms_license_plate_numbers
START WITH lpn_id = p_lpn_id
CONNECT BY parent_lpn_id = PRIOR lpn_id
)
)
)
)
UNION ALL
SELECT DISTINCT -9999 project_id,
l_no_proj_str project_number,
l_no_proj_str project_name
FROM po_req_distributions_all prd,
po_requisition_lines_all prl
WHERE prd.project_id IS NULL
AND prd.requisition_line_id = prl.requisition_line_id
AND prl.requisition_header_id = p_req_header_id
AND l_no_proj_str LIKE ( p_project_number )
AND ( p_item_id IS NULL
OR prl.item_id = p_item_id )
AND ( (p_lpn_id IS NULL) OR
(p_lpn_id IS NOT NULL AND EXISTS
( SELECT wlc.inventory_item_id
FROM wms_lpn_contents wlc
WHERE wlc.inventory_item_id = prl.item_id
AND wlc.parent_lpn_id IN
( SELECT lpn_id
FROM wms_license_plate_numbers
START WITH lpn_id = p_lpn_id
CONNECT BY parent_lpn_id = PRIOR lpn_id
)
)
)
);
SELECT DISTINCT p.project_id,
p.project_number,
p.project_name
FROM oe_order_lines_all oel,
pjm_projects_mtll_v p
WHERE oel.project_id IS NOT NULL
AND oel.project_id = p.project_id
AND oel.header_id = p_order_header_id
AND ( p_item_id IS NULL
OR ( oel.inventory_item_id = p_item_id ) )
AND p.project_number LIKE ( p_project_number );
SELECT DISTINCT p.project_id,
p.project_number,
p.project_name
FROM oe_order_lines_all oel,
pjm_projects_mtll_v p
WHERE oel.project_id IS NOT NULL
AND oel.project_id = p.project_id
AND oel.header_id = p_order_header_id
AND ( p_item_id IS NULL
OR ( oel.inventory_item_id = p_item_id ) )
AND p.project_number LIKE ( p_project_number )
UNION ALL
SELECT DISTINCT -9999 project_id,
l_no_proj_str project_number,
l_no_proj_str project_name
FROM oe_order_lines_all oel
WHERE oel.project_id IS NULL
AND oel.header_id = p_order_header_id
AND ( p_item_id IS NULL
OR ( oel.inventory_item_id = p_item_id ) )
AND l_no_proj_str LIKE ( p_project_number );
SELECT p.project_id,
NVL ( p.project_number, ' ' ),
NVL ( p.project_name, ' ' )
FROM pjm_projects_mtll_v p
WHERE p.project_number LIKE ( p_restrict_projects )
ORDER BY 2;
SELECT DISTINCT p.project_id,
NVL ( p.project_number, ' ' ),
NVL ( p.project_name, ' ' )
FROM pjm_projects_mtll_v p,
mtl_cycle_count_entries mcce,
mtl_item_locations mil
WHERE mil.segment19 = p.project_id
AND mcce.locator_id = mil.inventory_location_id
AND mcce.organization_id = mil.organization_id
AND mcce.cycle_count_header_id = p_cycle_count_id
AND p.project_number LIKE ( p_project_number )
ORDER BY 2;
SELECT p.project_id,
NVL ( p.project_number, ' ' ),
NVL ( p.project_name, ' ' )
FROM pjm_projects_mtll_v p
WHERE p.project_number LIKE ( p_project_number )
ORDER BY 2;
SELECT DISTINCT p.project_id,
NVL ( p.project_number, ' ' ),
NVL ( p.project_name, ' ' )
FROM pjm_projects_mtll_v p,
mtl_physical_inventory_tags mpi,
mtl_item_locations mil
WHERE mil.project_id = p.project_id
AND mil.inventory_location_id = mpi.locator_id
AND mil.organization_id = p_organization_id
AND mpi.physical_inventory_id =
p_physical_inventory_id
AND p.project_number LIKE ( p_project_number )
ORDER BY 2;
SELECT p.project_id,
NVL ( p.project_number, ' ' ),
NVL ( p.project_name, ' ' )
FROM pjm_projects_mtll_v p
WHERE p.project_number LIKE ( p_project_number )
ORDER BY 2;
SELECT p.project_id,
NVL ( p.project_number, ' ' ),
NVL ( p.project_name, ' ' )
FROM pjm_projects_mtll_v p
WHERE p.project_number LIKE ( p_restrict_projects )
AND p.project_id IN (
SELECT mtrl.project_id
FROM mtl_txn_request_lines mtrl
WHERE mtrl.organization_id = p_organization_id
AND mtrl.header_id = p_mo_header_id )
ORDER BY 2;