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_LINES_ALL

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 693: po_lines_all pla,

689: l_err_req_dist_num,
690: l_err_req_line_id,
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

Line 790: po_lines_all pla,

786: l_err_req_dist_num,
787: l_err_req_line_id,
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

Line 2244: po_lines_all pla,

2240: l_old_curr_amount,
2241: l_old_po_amount
2242: FROM
2243: po_headers_all pha,
2244: po_lines_all pla,
2245: po_line_locations_all plla,
2246: po_req_distributions_all prda,
2247: po_requisition_lines_all prla,
2248: po_requisition_headers_all prha,

Line 2325: po_lines_all pla,

2321: l_old_curr_amount,
2322: l_old_po_amount
2323: FROM
2324: po_headers_all pha,
2325: po_lines_all pla,
2326: po_line_locations_all plla,
2327: po_requisition_lines_all prla,
2328: po_requisition_headers_all prha
2329: WHERE

Line 2415: po_lines_all pla,

2411: l_old_po_amount
2412: FROM
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,

Line 2498: po_lines_all pla,

2494: l_old_po_amount
2495: FROM
2496: po_headers_all pha,
2497: po_releases_all pra,
2498: po_lines_all pla,
2499: po_line_locations_all plla,
2500: po_requisition_lines_all prla,
2501: po_requisition_headers_all prha
2502: WHERE

Line 2937: po_lines_all pla,

2933: l_billed_amount,
2934: l_receipt_required_flag
2935: FROM
2936: po_headers_all pha,
2937: po_lines_all pla,
2938: po_line_locations_all plla,
2939: po_requisition_lines_all prla
2940: WHERE
2941: prla.requisition_line_id = p_req_line_id

Line 3270: l_allow_price_override_flag po_lines_all.allow_price_override_flag%TYPE;

3266: l_frozen_flag VARCHAR2(1);
3267: l_closed_code po_headers_all.closed_code%TYPE;
3268: l_cancel_flag po_headers_all.cancel_flag%TYPE;
3269: l_catalog_type po_requisition_lines_all.catalog_type%TYPE;
3270: l_allow_price_override_flag po_lines_all.allow_price_override_flag%TYPE;
3271: l_accrue_on_receipt_flag po_line_locations_all.accrue_on_receipt_flag%TYPE;
3272: l_qty_received NUMBER;
3273: l_qty_billed NUMBER;
3274: l_count NUMBER;

Line 3434: po_lines_all pla

3430: SELECT pla.allow_price_override_flag
3431: INTO l_allow_price_override_flag
3432: FROM po_requisition_lines_all prl,
3433: po_headers_all pha,
3434: po_lines_all pla
3435: WHERE pha.po_header_id = l_po_header_id
3436: AND pla.po_header_id = pha.po_header_id
3437: AND prl.blanket_po_line_num = pla.line_num
3438: AND prl.requisition_line_id = p_req_line_id;

Line 3533: po_lines_all pla,

3529: l_qty_billed,
3530: l_frozen_flag
3531: FROM
3532: po_headers_all pha,
3533: po_lines_all pla,
3534: po_line_locations_all plla,
3535: po_requisition_lines_all prla
3536: WHERE pha.po_header_id = plla.po_header_id
3537: AND pla.po_line_id = plla.po_line_id

Line 3562: po_lines_all pla,

3558: l_qty_received,
3559: l_qty_billed,
3560: l_frozen_flag
3561: FROM
3562: po_lines_all pla,
3563: po_line_locations_all plla,
3564: po_requisition_lines_all prla,
3565: po_releases_all pra
3566: WHERE pla.po_line_id = plla.po_line_id

Line 3577: FROM po_lines_all pla,

3573:
3574: --Bug:16423039 Consider the override flag on GBPA/BPA in RCO,NOT SPO/BPA Release
3575: SELECT DECODE(prla.document_type_code,'BLANKET',NVL(pla.allow_price_override_flag, 'N'),'Y')
3576: INTO l_allow_price_override_flag
3577: FROM po_lines_all pla,
3578: po_requisition_lines_all prla
3579: WHERE pla.line_num(+) = prla.blanket_po_line_num
3580: AND pla.po_header_id(+) = prla.blanket_po_header_id
3581: and prla.requisition_line_id = p_req_line_id;

Line 4478: po_lines_all pla,

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
4482: AND prda.requisition_line_id = prla.requisition_line_id