APPS.INV_RCV_TXN_MATCH dependencies on PO_DISTRIBUTIONS_ALL

Line 299: from po_distributions_all pod

295: -- bug 2752051
296: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
297: AND exists
298: ( select '1'
299: from po_distributions_all pod
300: where pod.line_location_id = poll.line_location_id
301: and (v_project_id is null or
302: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
303: pod.project_id = v_project_id

Line 353: from po_distributions_all pod

349: -- bug 2752051
350: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
351: AND exists
352: ( select '1'
353: from po_distributions_all pod
354: where pod.line_location_id = poll.line_location_id
355: and (v_project_id is null or
356: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
357: pod.project_id = v_project_id

Line 408: from po_distributions_all pod

404: -- bug 2752051
405: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
406: AND exists
407: ( select '1'
408: from po_distributions_all pod
409: where pod.line_location_id = poll.line_location_id
410: and (v_project_id is null or
411: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
412: pod.project_id = v_project_id

Line 450: from po_distributions_all pod

446: -- bug 2752051
447: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
448: AND exists
449: ( select '1'
450: from po_distributions_all pod
451: where pod.line_location_id = poll.line_location_id
452: and (v_project_id is null or
453: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
454: pod.project_id = v_project_id

Line 694: from po_distributions_all pod

690: -- bug 2752051
691: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
692: AND exists
693: ( select '1'
694: from po_distributions_all pod
695: where pod.line_location_id = poll.line_location_id
696: and (v_project_id is null or
697: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
698: pod.project_id = v_project_id

Line 741: from po_distributions_all pod

737: -- bug 2752051
738: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
739: AND exists
740: ( select '1'
741: from po_distributions_all pod
742: where pod.line_location_id = poll.line_location_id
743: and (v_project_id is null or
744: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
745: pod.project_id = v_project_id

Line 796: from po_distributions_all pod

792: -- bug 2752051
793: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
794: AND exists
795: ( select '1'
796: from po_distributions_all pod
797: where pod.line_location_id = poll.line_location_id
798: and (v_project_id is null or
799: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
800: pod.project_id = v_project_id

Line 831: from po_distributions_all pod

827: -- bug 2752051
828: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
829: AND exists
830: ( select '1'
831: from po_distributions_all pod
832: where pod.line_location_id = poll.line_location_id
833: and (v_project_id is null or
834: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
835: pod.project_id = v_project_id