DBA Data[Home] [Help]

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

2203: l_old_curr_amount,
2204: l_old_po_amount
2205: FROM
2206: po_headers_all pha,
2207: po_lines_all pla,
2208: po_line_locations_all plla,
2209: po_req_distributions_all prda,
2210: po_requisition_lines_all prla,
2211: po_requisition_headers_all prha,

Line 2288: po_lines_all pla,

2284: l_old_curr_amount,
2285: l_old_po_amount
2286: FROM
2287: po_headers_all pha,
2288: po_lines_all pla,
2289: po_line_locations_all plla,
2290: po_requisition_lines_all prla,
2291: po_requisition_headers_all prha
2292: WHERE

Line 2378: po_lines_all pla,

2374: l_old_po_amount
2375: FROM
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,

Line 2461: po_lines_all pla,

2457: l_old_po_amount
2458: FROM
2459: po_headers_all pha,
2460: po_releases_all pra,
2461: po_lines_all pla,
2462: po_line_locations_all plla,
2463: po_requisition_lines_all prla,
2464: po_requisition_headers_all prha
2465: WHERE

Line 2873: po_lines_all pla,

2869: l_billed_amount,
2870: l_receipt_required_flag
2871: FROM
2872: po_headers_all pha,
2873: po_lines_all pla,
2874: po_line_locations_all plla,
2875: po_requisition_lines_all prla
2876: WHERE
2877: prla.requisition_line_id = p_req_line_id

Line 3206: l_allow_price_override_flag po_lines_all.allow_price_override_flag%TYPE;

3202: l_frozen_flag VARCHAR2(1);
3203: l_closed_code po_headers_all.closed_code%TYPE;
3204: l_cancel_flag po_headers_all.cancel_flag%TYPE;
3205: l_catalog_type po_requisition_lines_all.catalog_type%TYPE;
3206: l_allow_price_override_flag po_lines_all.allow_price_override_flag%TYPE;
3207: l_accrue_on_receipt_flag po_line_locations_all.accrue_on_receipt_flag%TYPE;
3208: l_qty_received NUMBER;
3209: l_qty_billed NUMBER;
3210: l_count NUMBER;

Line 3363: po_lines_all pla

3359: SELECT pla.allow_price_override_flag
3360: INTO l_allow_price_override_flag
3361: FROM po_requisition_lines_all prl,
3362: po_headers_all pha,
3363: po_lines_all pla
3364: WHERE pha.po_header_id = l_po_header_id
3365: AND pla.po_header_id = pha.po_header_id
3366: AND prl.blanket_po_line_num = pla.line_num
3367: AND prl.requisition_line_id = p_req_line_id;

Line 3462: po_lines_all pla,

3458: l_qty_billed,
3459: l_frozen_flag
3460: FROM
3461: po_headers_all pha,
3462: po_lines_all pla,
3463: po_line_locations_all plla,
3464: po_requisition_lines_all prla
3465: WHERE pha.po_header_id = plla.po_header_id
3466: AND pla.po_line_id = plla.po_line_id

Line 3491: po_lines_all pla,

3487: l_qty_received,
3488: l_qty_billed,
3489: l_frozen_flag
3490: FROM
3491: po_lines_all pla,
3492: po_line_locations_all plla,
3493: po_requisition_lines_all prla,
3494: po_releases_all pra
3495: WHERE pla.po_line_id = plla.po_line_id

Line 4395: po_lines_all pla,

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