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 2249: po_distributions_all pda

2245: po_line_locations_all plla,
2246: po_req_distributions_all prda,
2247: po_requisition_lines_all prla,
2248: po_requisition_headers_all prha,
2249: po_distributions_all pda
2250: WHERE
2251: prda.distribution_id = req_change_record_tbl(req_index).document_distribution_id
2252: AND prda.requisition_line_id = prla.requisition_line_id
2253: AND prla.line_location_id = plla.line_location_id

Line 2417: po_distributions_all pda,

2413: po_headers_all pha,
2414: po_releases_all pra,
2415: po_lines_all pla,
2416: po_line_locations_all plla,
2417: po_distributions_all pda,
2418: po_req_distributions_all prda,
2419: po_requisition_lines_all prla,
2420: po_requisition_headers_all prha
2421: WHERE

Line 2895: po_distributions_all pda,

2891: SELECT COUNT(DISTINCT nvl(prda.requisition_line_id, - 1))
2892: INTO l_count
2893: FROM
2894: po_req_distributions_all prda,
2895: po_distributions_all pda,
2896: po_requisition_lines_all prla
2897: WHERE pda.line_location_id = prla.line_location_id
2898: AND prla.requisition_line_id = p_req_line_id
2899: AND pda.req_distribution_id = prda.distribution_id(+ );

Line 3119: po_distributions_all pod,

3115: SELECT 1
3116: INTO l_dist_not_valid
3117: FROM
3118: po_line_locations_all poll,
3119: po_distributions_all pod,
3120: gl_code_combinations gcc
3121: WHERE
3122: poll.line_location_id = l_po_line_loc_id AND
3123: pod.line_location_id = poll.line_location_id AND

Line 3621: po_distributions_all pda,

3617: SELECT COUNT(DISTINCT nvl(prda.requisition_line_id, - 1))
3618: INTO l_count
3619: FROM
3620: po_req_distributions_all prda,
3621: po_distributions_all pda,
3622: po_requisition_lines_all prla
3623: WHERE pda.line_location_id = prla.line_location_id
3624: AND prla.requisition_line_id = p_req_line_id
3625: AND pda.req_distribution_id = prda.distribution_id(+ );

Line 4247: po_distributions_all pda,

4243: pda.po_distribution_id
4244: FROM
4245: po_change_requests pcr,
4246: po_req_distributions_all prda,
4247: po_distributions_all pda,
4248: po_headers_all pha
4249: WHERE
4250: pcr.change_request_group_id = grp_id AND
4251: (pcr.new_quantity IS NOT NULL OR pcr.new_amount IS NOT NULL) AND

Line 4264: po_distributions_all pda,

4260: FROM
4261: po_change_requests pcr,
4262: po_requisition_lines_all prla,
4263: po_req_distributions_all prda,
4264: po_distributions_all pda,
4265: po_headers_all pha
4266: WHERE
4267: pcr.change_request_group_id = grp_id AND
4268: pcr.action_type = 'MODIFICATION' AND

Line 4283: po_distributions_all pda,

4279: pda.po_distribution_id
4280: FROM
4281: po_change_requests pcr,
4282: po_req_distributions_all prda,
4283: po_distributions_all pda,
4284: po_requisition_lines_all prla,
4285: po_line_locations_all plla
4286: WHERE
4287: pcr.change_request_group_id = grp_id AND

Line 4302: po_distributions_all pda,

4298: FROM
4299: po_change_requests pcr,
4300: po_requisition_lines_all prla,
4301: po_req_distributions_all prda,
4302: po_distributions_all pda,
4303: po_line_locations_all plla
4304: WHERE
4305: pcr.change_request_group_id = grp_id AND
4306: pcr.action_type = 'MODIFICATION' AND

Line 4477: po_distributions_all pda,

4473: FROM
4474: po_req_distributions_all prda,
4475: po_requisition_lines_all prla,
4476: po_line_locations_all plla,
4477: po_distributions_all pda,
4478: po_lines_all pla,
4479: po_headers_all pha
4480: WHERE
4481: prda.distribution_id = l_req_dist_id

Line 4497: FROM po_distributions_All pda

4493: SELECT pda.SET_OF_BOOKS_ID,
4494: pda.GL_ENCUMBERED_DATE
4495: INTO l_set_of_books_id,
4496: l_gl_date
4497: FROM po_distributions_All pda
4498: WHERE pda.po_distribution_id = l_distribution_id
4499: AND pda.ENCUMBERED_FLAG = 'Y';
4500:
4501: -- check if GL period is open

Line 4730: po_distributions_all pda

4726: l_fc_req_line_num
4727: FROM
4728: po_requisition_lines_all prla,
4729: po_req_distributions_all prda,
4730: po_distributions_all pda
4731: WHERE
4732: pda.po_distribution_id = l_fc_out_tbl.distribution_id(x)
4733: AND pda.req_distribution_id = prda.distribution_id
4734: AND prla.requisition_line_id = prda.requisition_line_id;

Line 6649: po_distributions_all pda

6645: l_fc_req_line_num
6646: FROM
6647: po_requisition_lines_all prla,
6648: po_req_distributions_all prda,
6649: po_distributions_all pda
6650: WHERE
6651: pda.po_distribution_id = l_fc_out_tbl.distribution_id(x)
6652: AND pda.req_distribution_id = prda.distribution_id
6653: AND prla.requisition_line_id = prda.requisition_line_id;