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_HEADERS_ALL

Line 873: l_blanket_num po_headers_all.segment1%TYPE;

869: x_return_msg OUT NOCOPY VARCHAR2)
870: IS
871: l_api_name VARCHAR2(50) := 'decode_POError';
872: l_progress VARCHAR2(5) := '000';
873: l_blanket_num po_headers_all.segment1%TYPE;
874: l_po_num po_headers_all.segment1%TYPE;
875: l_release_num NUMBER;
876: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
877: l_doc_type VARCHAR2(2000);

Line 874: l_po_num po_headers_all.segment1%TYPE;

870: IS
871: l_api_name VARCHAR2(50) := 'decode_POError';
872: l_progress VARCHAR2(5) := '000';
873: l_blanket_num po_headers_all.segment1%TYPE;
874: l_po_num po_headers_all.segment1%TYPE;
875: l_release_num NUMBER;
876: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
877: l_doc_type VARCHAR2(2000);
878: l_doc_num po_headers_all.segment1%TYPE;

Line 876: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

872: l_progress VARCHAR2(5) := '000';
873: l_blanket_num po_headers_all.segment1%TYPE;
874: l_po_num po_headers_all.segment1%TYPE;
875: l_release_num NUMBER;
876: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
877: l_doc_type VARCHAR2(2000);
878: l_doc_num po_headers_all.segment1%TYPE;
879: l_err_po_line_num NUMBER;
880: BEGIN

Line 878: l_doc_num po_headers_all.segment1%TYPE;

874: l_po_num po_headers_all.segment1%TYPE;
875: l_release_num NUMBER;
876: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
877: l_doc_type VARCHAR2(2000);
878: l_doc_num po_headers_all.segment1%TYPE;
879: l_err_po_line_num NUMBER;
880: BEGIN
881: x_return_status := fnd_api.g_ret_sts_success;
882:

Line 892: FROM po_headers_all

888: type_lookup_code
889: INTO
890: l_po_num,
891: l_type_lookup_code
892: FROM po_headers_all
893: WHERE po_header_id = p_header_id;
894:
895: IF(l_type_lookup_code = 'STANDARD') THEN
896: l_doc_type := fnd_message.get_string('PO', 'PO_WF_NOTIF_STD_PO');

Line 913: FROM po_headers_all pha,

909: INTO
910: l_blanket_num,
911: l_release_num,
912: l_type_lookup_code
913: FROM po_headers_all pha,
914: po_releases_all pra
915: WHERE pra.po_release_id = p_release_id
916: AND pra.po_header_id = pha.po_header_id;
917:

Line 2089: l_po_num po_headers_all.segment1%TYPE;

2085: IS
2086: l_api_name VARCHAR2(50) := 'Copy_Change';
2087: l_progress VARCHAR2(3) := '000';
2088: l_po_doc_type VARCHAR2(30);
2089: l_po_num po_headers_all.segment1%TYPE;
2090: l_po_revision_num NUMBER;
2091: l_po_line_id NUMBER;
2092: l_po_line_number NUMBER;
2093: l_po_line_location_id NUMBER;

Line 2206: po_headers_all pha,

2202: l_old_amount,
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,

Line 2287: po_headers_all pha,

2283: l_old_amount,
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

Line 2376: po_headers_all pha,

2372: l_old_amount,
2373: l_old_curr_amount,
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,

Line 2459: po_headers_all pha,

2455: l_old_amount,
2456: l_old_curr_amount,
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,

Line 2872: po_headers_all pha,

2868: l_received_amount,
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

Line 3105: FROM po_headers_all

3101:
3102: -- get org id of the PO
3103: SELECT org_id
3104: INTO l_po_org_id
3105: FROM po_headers_all
3106: WHERE po_header_id = l_po_header_id;
3107: ELSE
3108: l_po_doc_type := 'RELEASE';
3109: l_po_doc_subtype := 'BLANKET';

Line 3201: l_authorization_status po_headers_all.authorization_status%TYPE;

3197: l_source_type_code po_requisition_lines_all.source_type_code%TYPE;
3198: l_auction_display_number po_requisition_lines_all.auction_display_number%TYPE;
3199: l_auction_line_number NUMBER;
3200: l_reqs_in_pool_flag po_requisition_lines_all.reqs_in_pool_flag%TYPE;
3201: l_authorization_status po_headers_all.authorization_status%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;

Line 3203: l_closed_code po_headers_all.closed_code%TYPE;

3199: l_auction_line_number NUMBER;
3200: l_reqs_in_pool_flag po_requisition_lines_all.reqs_in_pool_flag%TYPE;
3201: l_authorization_status po_headers_all.authorization_status%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;

Line 3204: l_cancel_flag po_headers_all.cancel_flag%TYPE;

3200: l_reqs_in_pool_flag po_requisition_lines_all.reqs_in_pool_flag%TYPE;
3201: l_authorization_status po_headers_all.authorization_status%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;

Line 3214: l_global_agreement_flag po_headers_all.global_agreement_flag%TYPE;

3210: l_count NUMBER;
3211: l_release_id NUMBER;
3212: l_return_status VARCHAR2(1);
3213: l_line_type po_line_types.purchase_basis%TYPE;
3214: l_global_agreement_flag po_headers_all.global_agreement_flag%TYPE;
3215: l_order_type_lookup_code po_requisition_lines_all.order_type_lookup_code%TYPE ;
3216: l_po_header_id po_headers_all.po_header_id%TYPE;
3217: l_template_id po_requisition_lines_all.noncat_template_id%TYPE;
3218: l_price_editable_flag por_noncat_templates_all_b.price_editable_flag%TYPE;

Line 3216: l_po_header_id po_headers_all.po_header_id%TYPE;

3212: l_return_status VARCHAR2(1);
3213: l_line_type po_line_types.purchase_basis%TYPE;
3214: l_global_agreement_flag po_headers_all.global_agreement_flag%TYPE;
3215: l_order_type_lookup_code po_requisition_lines_all.order_type_lookup_code%TYPE ;
3216: l_po_header_id po_headers_all.po_header_id%TYPE;
3217: l_template_id po_requisition_lines_all.noncat_template_id%TYPE;
3218: l_price_editable_flag por_noncat_templates_all_b.price_editable_flag%TYPE;
3219: l_amount_editable_flag por_noncat_templates_all_b.amount_editable_flag%TYPE;
3220: -- added for retroactive pricing checks

Line 3352: FROM po_headers_all pha,

3348: -- if there is not a backing GBPA, the labor anount can be changed
3349:
3350: SELECT pha.global_agreement_flag, pha.po_header_id
3351: INTO l_global_agreement_flag, l_po_header_id
3352: FROM po_headers_all pha,
3353: po_requisition_lines_all prla
3354: WHERE pha.po_header_id (+ ) = prla.blanket_po_header_id
3355: AND prla.requisition_line_id = p_req_line_id;
3356:

Line 3362: po_headers_all pha,

3358: BEGIN
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

Line 3461: po_headers_all pha,

3457: l_qty_received,
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

Line 3917: FROM po_headers_all

3913: WHERE line_location_id = l_line_loc_id;
3914: IF(l_po_release_id IS NULL) THEN
3915: SELECT revision_num, segment1 INTO
3916: l_po_revision_num, l_po_num
3917: FROM po_headers_all
3918: WHERE po_header_id = l_po_header_id;
3919:
3920: -- bug 5191164.
3921: -- Need to null out l_po_release_num for PO records

Line 3927: FROM po_headers_all

3923:
3924: ELSE
3925: -- get po_number of the source document for RELEASE
3926: SELECT segment1 INTO l_po_num
3927: FROM po_headers_all
3928: WHERE po_header_id = l_po_header_id;
3929:
3930: SELECT revision_num, release_num
3931: INTO l_po_revision_num, l_po_release_num

Line 4040: l_po_num po_headers_all.segment1%TYPE;

4036: l_req_dist_id NUMBER;
4037: l_req_line_id NUMBER;
4038: l_req_hdr_id NUMBER;
4039: l_req_num po_requisition_headers_all.segment1%TYPE;
4040: l_po_num po_headers_all.segment1%TYPE;
4041: l_header_id NUMBER;
4042: l_release_id NUMBER;
4043: l_line_id NUMBER;
4044: l_shipment_id NUMBER;

Line 4165: po_headers_all pha

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
4169: pcr.action_type = 'MODIFICATION' AND

Line 4182: po_headers_all pha

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
4186: (pcr.new_price IS NOT NULL OR pcr.new_need_by_date IS NOT NULL) AND

Line 4396: po_headers_all pha

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
4400: AND pda.req_distribution_id = prda.distribution_id

Line 5294: from po_headers_all

5290: where line_location_id = l_line_loc_id;
5291: if(l_po_release_id is null) then
5292: select revision_num,segment1 into
5293: l_po_revision_num, l_po_num
5294: from po_headers_all
5295: where po_header_id = l_po_header_id;
5296:
5297: -- bug 5191164.
5298: -- Need to null out l_po_release_num for PO records

Line 5304: from po_headers_all

5300:
5301: else
5302: -- get po_number of the source document for RELEASE
5303: select segment1 into l_po_num
5304: from po_headers_all
5305: where po_header_id = l_po_header_id;
5306:
5307: select revision_num, release_num
5308: into l_po_revision_num, l_po_release_num