eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_RCO_VALIDATION_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 656: FROM po_distributions_all

652: quantity_billed
653: INTO
654: l_qty_old_del,
655: l_qty_old_bill
656: FROM po_distributions_all
657: WHERE po_distribution_id = p_po_change_table(s).document_distribution_id;
658: */
659: -- Code commented and new code added for bug 7138977
660: select

Line 665: from po_distributions_all dist, po_lines_all line

661: dist.quantity_delivered * Decode(line.ORDER_TYPE_LOOKUP_CODE,'AMOUNT', Nvl(dist.rate,1),1), dist.quantity_billed * Decode(line.ORDER_TYPE_LOOKUP_CODE,'AMOUNT', Nvl(dist.rate,1),1)
662: into
663: l_qty_old_del,
664: l_qty_old_bill
665: from po_distributions_all dist, po_lines_all line
666: where dist.po_line_id = line.po_line_id AND
667: dist.po_distribution_id = p_po_change_table(s).document_distribution_id;
668:
669: IF (g_fnd_debug = 'Y') THEN

Line 695: po_distributions_all pda,

691: l_err_req_dist_id
692: FROM
693: po_lines_all pla,
694: po_line_locations_all plla,
695: po_distributions_all pda,
696: po_requisition_lines_all prla,
697: po_req_distributions_all prda
698: WHERE
699: pla.po_header_id = p_header_id

Line 721: po_distributions_all pda,

717: l_err_req_line_id,
718: l_err_req_dist_id
719: FROM
720: po_line_locations_all plla,
721: po_distributions_all pda,
722: po_requisition_lines_all prla,
723: po_req_distributions_all prda
724: WHERE
725: plla.po_release_id = p_release_id

Line 756: po_distributions_all pda

752: SELECT plla.quantity_received
753: INTO l_qty_old_rec
754: FROM
755: po_line_locations_all plla,
756: po_distributions_all pda
757: WHERE plla.line_location_id = pda.line_location_id
758: AND pda.po_distribution_id = p_po_change_table(s).document_distribution_id;
759:
760: x_return_msg := 'VQ005';

Line 766: po_distributions_all pda1,

762: SELECT SUM(plla.quantity_received) + p_po_change_table(s).new_quantity
763: INTO l_qty_new_rec
764: FROM
765: po_line_locations_all plla,
766: po_distributions_all pda1,
767: po_distributions_all pda2
768: WHERE plla.line_location_id = pda1.line_location_id
769: AND pda1.po_distribution_id <> p_po_change_table(s).document_distribution_id
770: AND pda1.line_location_id = pda2.line_location_id

Line 767: po_distributions_all pda2

763: INTO l_qty_new_rec
764: FROM
765: po_line_locations_all plla,
766: po_distributions_all pda1,
767: po_distributions_all pda2
768: WHERE plla.line_location_id = pda1.line_location_id
769: AND pda1.po_distribution_id <> p_po_change_table(s).document_distribution_id
770: AND pda1.line_location_id = pda2.line_location_id
771: AND pda2.po_distribution_id = p_po_change_table(s).document_distribution_id;

Line 792: po_distributions_all pda,

788: l_err_req_dist_id
789: FROM
790: po_lines_all pla,
791: po_line_locations_all plla,
792: po_distributions_all pda,
793: po_requisition_lines_all prla,
794: po_req_distributions_all prda
795: WHERE
796: pla.po_header_id = p_header_id

Line 818: po_distributions_all pda,

814: l_err_req_line_id,
815: l_err_req_dist_id
816: FROM
817: po_line_locations_all plla,
818: po_distributions_all pda,
819: po_requisition_lines_all prla,
820: po_req_distributions_all prda
821: WHERE
822: plla.po_release_id = p_release_id

Line 2212: po_distributions_all pda

2208: po_line_locations_all plla,
2209: po_req_distributions_all prda,
2210: po_requisition_lines_all prla,
2211: po_requisition_headers_all prha,
2212: po_distributions_all pda
2213: WHERE
2214: prda.distribution_id = req_change_record_tbl(req_index).document_distribution_id
2215: AND prda.requisition_line_id = prla.requisition_line_id
2216: AND prla.line_location_id = plla.line_location_id

Line 2380: po_distributions_all pda,

2376: po_headers_all pha,
2377: po_releases_all pra,
2378: po_lines_all pla,
2379: po_line_locations_all plla,
2380: po_distributions_all pda,
2381: po_req_distributions_all prda,
2382: po_requisition_lines_all prla,
2383: po_requisition_headers_all prha
2384: WHERE

Line 2831: po_distributions_all pda,

2827: SELECT COUNT(DISTINCT nvl(prda.requisition_line_id, - 1))
2828: INTO l_count
2829: FROM
2830: po_req_distributions_all prda,
2831: po_distributions_all pda,
2832: po_requisition_lines_all prla
2833: WHERE pda.line_location_id = prla.line_location_id
2834: AND prla.requisition_line_id = p_req_line_id
2835: AND pda.req_distribution_id = prda.distribution_id(+ );

Line 3055: po_distributions_all pod,

3051: SELECT 1
3052: INTO l_dist_not_valid
3053: FROM
3054: po_line_locations_all poll,
3055: po_distributions_all pod,
3056: gl_code_combinations gcc
3057: WHERE
3058: poll.line_location_id = l_po_line_loc_id AND
3059: pod.line_location_id = poll.line_location_id AND

Line 3540: po_distributions_all pda,

3536: SELECT COUNT(DISTINCT nvl(prda.requisition_line_id, - 1))
3537: INTO l_count
3538: FROM
3539: po_req_distributions_all prda,
3540: po_distributions_all pda,
3541: po_requisition_lines_all prla
3542: WHERE pda.line_location_id = prla.line_location_id
3543: AND prla.requisition_line_id = p_req_line_id
3544: AND pda.req_distribution_id = prda.distribution_id(+ );

Line 4164: po_distributions_all pda,

4160: pda.po_distribution_id
4161: FROM
4162: po_change_requests pcr,
4163: po_req_distributions_all prda,
4164: po_distributions_all pda,
4165: po_headers_all pha
4166: WHERE
4167: pcr.change_request_group_id = grp_id AND
4168: (pcr.new_quantity IS NOT NULL OR pcr.new_amount IS NOT NULL) AND

Line 4181: po_distributions_all pda,

4177: FROM
4178: po_change_requests pcr,
4179: po_requisition_lines_all prla,
4180: po_req_distributions_all prda,
4181: po_distributions_all pda,
4182: po_headers_all pha
4183: WHERE
4184: pcr.change_request_group_id = grp_id AND
4185: pcr.action_type = 'MODIFICATION' AND

Line 4200: po_distributions_all pda,

4196: pda.po_distribution_id
4197: FROM
4198: po_change_requests pcr,
4199: po_req_distributions_all prda,
4200: po_distributions_all pda,
4201: po_requisition_lines_all prla,
4202: po_line_locations_all plla
4203: WHERE
4204: pcr.change_request_group_id = grp_id AND

Line 4219: po_distributions_all pda,

4215: FROM
4216: po_change_requests pcr,
4217: po_requisition_lines_all prla,
4218: po_req_distributions_all prda,
4219: po_distributions_all pda,
4220: po_line_locations_all plla
4221: WHERE
4222: pcr.change_request_group_id = grp_id AND
4223: pcr.action_type = 'MODIFICATION' AND

Line 4394: po_distributions_all pda,

4390: FROM
4391: po_req_distributions_all prda,
4392: po_requisition_lines_all prla,
4393: po_line_locations_all plla,
4394: po_distributions_all pda,
4395: po_lines_all pla,
4396: po_headers_all pha
4397: WHERE
4398: prda.distribution_id = l_req_dist_id

Line 4594: po_distributions_all pda

4590: l_fc_req_line_num
4591: FROM
4592: po_requisition_lines_all prla,
4593: po_req_distributions_all prda,
4594: po_distributions_all pda
4595: WHERE
4596: pda.po_distribution_id = l_fc_out_tbl.distribution_id(x)
4597: AND pda.req_distribution_id = prda.distribution_id
4598: AND prla.requisition_line_id = prda.requisition_line_id;

Line 6598: po_distributions_all pda

6594: l_fc_req_line_num
6595: FROM
6596: po_requisition_lines_all prla,
6597: po_req_distributions_all prda,
6598: po_distributions_all pda
6599: WHERE
6600: pda.po_distribution_id = l_fc_out_tbl.distribution_id(x)
6601: AND pda.req_distribution_id = prda.distribution_id
6602: AND prla.requisition_line_id = prda.requisition_line_id;