APPS.INV_RCV_TXN_MATCH dependencies on PO_DISTRIBUTIONS_ALL

Line 336: from po_distributions_all pod

332: -- bug 2752051
333: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
334: AND exists
335: ( select '1'
336: from po_distributions_all pod
337: where pod.line_location_id = poll.line_location_id
338: and (v_project_id is null or
339: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
340: pod.project_id = v_project_id

Line 406: from po_distributions_all pod

402: )
403: )
404: AND exists
405: ( select '1'
406: from po_distributions_all pod
407: where pod.line_location_id = poll.line_location_id
408: and (v_project_id is null or
409: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
410: pod.project_id = v_project_id

Line 465: from po_distributions_all pod

461: -- bug 2752051
462: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
463: AND exists
464: ( select '1'
465: from po_distributions_all pod
466: where pod.line_location_id = poll.line_location_id
467: and (v_project_id is null or
468: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
469: pod.project_id = v_project_id

Line 521: from po_distributions_all pod

517: )
518: )
519: AND exists
520: ( select '1'
521: from po_distributions_all pod
522: where pod.line_location_id = poll.line_location_id
523: and (v_project_id is null or
524: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
525: pod.project_id = v_project_id

Line 767: from po_distributions_all pod

763: -- bug 2752051
764: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
765: AND exists
766: ( select '1'
767: from po_distributions_all pod
768: where pod.line_location_id = poll.line_location_id
769: and (v_project_id is null or
770: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
771: pod.project_id = v_project_id

Line 814: from po_distributions_all pod

810: -- bug 2752051
811: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
812: AND exists
813: ( select '1'
814: from po_distributions_all pod
815: where pod.line_location_id = poll.line_location_id
816: and (v_project_id is null or
817: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
818: pod.project_id = v_project_id

Line 869: from po_distributions_all pod

865: -- bug 2752051
866: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
867: AND exists
868: ( select '1'
869: from po_distributions_all pod
870: where pod.line_location_id = poll.line_location_id
871: and (v_project_id is null or
872: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
873: pod.project_id = v_project_id

Line 904: from po_distributions_all pod

900: -- bug 2752051
901: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
902: AND exists
903: ( select '1'
904: from po_distributions_all pod
905: where pod.line_location_id = poll.line_location_id
906: and (v_project_id is null or
907: (v_project_id = -9999 and pod.project_id is null) or -- bug2669021
908: pod.project_id = v_project_id