[Home] [Help]
73: AND rsl.shipment_header_id = v_shipment_header_id
74: AND rsl.po_line_location_id = pll.line_location_id
75: AND pll.po_line_id = wlc.source_line_id (+)
76: AND pll.line_location_id in
77: ( select pod.line_location_id from po_distributions pod
78: where (v_project_id is null or
79: (v_project_id = -9999 and pod.project_id is null) or --Bug# 2669021
80: pod.project_id = v_project_id
81: )
128: AND rsl.po_line_location_id = pll.line_location_id
129: AND pll.po_line_id = wlc.source_line_id (+)
130: AND pll.line_location_id in
131: ( select pod.line_location_id
132: from po_distributions pod
133: where ( v_project_id is null or
134: (v_project_id = -9999 and pod.project_id is null) or --Bug# 2669021
135: pod.project_id = v_project_id
136: )
197: AND rsl.po_line_location_id = pll.line_location_id
198: AND pll.po_line_id = wlc.source_line_id (+)
199: AND pll.line_location_id in
200: ( select pod.line_location_id
201: from po_distributions pod
202: where ( v_project_id is null or
203: (v_project_id = -9999 and pod.project_id is null) or --Bug# 2669021
204: pod.project_id = v_project_id
205: )
255: AND rsl.po_line_location_id = pll.line_location_id
256: AND pll.po_line_id = wlc.source_line_id (+)
257: AND pll.line_location_id in
258: ( select pod.line_location_id
259: from po_distributions pod
260: where ( v_project_id is null or
261: (v_project_id = -9999 and pod.project_id is null) or --Bug# 2669021
262: pod.project_id = v_project_id
263: )
317: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
318: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
319: AND pll.line_location_id in
320: ( select pod.line_location_id
321: from po_distributions pod
322: where (v_project_id is null
323: or ((v_project_id = -9999 and pod.project_id is null)--Bug# 2669021
324: or (nvl(pod.project_id,-99) = v_project_id )))
325: and (v_task_id is null or nvl(pod.task_id,-9999) = v_task_id)
366: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
367: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
368: AND pll.line_location_id in
369: ( select pod.line_location_id
370: from po_distributions pod
371: where (v_project_id is null
372: or ((v_project_id = -9999 and pod.project_id is null)--Bug# 2669021
373: or (nvl(pod.project_id,-99) = v_project_id )))
374: and (v_task_id is null or nvl(pod.task_id,-9999) = v_task_id)
401: ,pll.ship_to_location_id
402: ,nvl(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code
403: ,0 rcv_transaction_id -- only need it for std_deliver
404: ,pl.item_revision --only needed for std_deliver
405: from po_distributions pod,
406: po_line_locations pll,
407: po_lines pl,
408: po_headers ph
409: where ph.po_header_id = header_id
449: , v_item_desc VARCHAR2
450: , v_project_id NUMBER
451: , v_task_id NUMBER) is
452: select count(*)
453: from po_distributions pod,
454: po_line_locations pll,
455: po_lines pl
456: where pll.po_header_id = header_id
457: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)
508: ,pll.ship_to_location_id
509: ,nvl(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code
510: ,rs.rcv_transaction_id
511: ,rs.item_revision
512: from po_distributions pod,
513: po_line_locations pll,
514: po_lines pl,
515: po_headers ph,
516: rcv_supply rs,
585: , v_txn_date DATE
586: , v_inspection_status VARCHAR2
587: , v_lpn_id NUMBER) is
588: select count(*)
589: from po_distributions pod,
590: po_line_locations pll,
591: po_lines pl,
592: po_headers ph,
593: rcv_supply rs,