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: l_vdr_cntct_id po_vendor_contacts.vendor_contact_id%TYPE;

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: l_vdr_cntct_id po_vendor_contacts.vendor_contact_id%TYPE;
881: l_buyer_id po_headers_all.agent_id%TYPE;
882: l_vdr_cntct_name varchar2(25);

Line 881: l_buyer_id po_headers_all.agent_id%TYPE;

877: l_doc_type VARCHAR2(2000);
878: l_doc_num po_headers_all.segment1%TYPE;
879: l_err_po_line_num NUMBER;
880: l_vdr_cntct_id po_vendor_contacts.vendor_contact_id%TYPE;
881: l_buyer_id po_headers_all.agent_id%TYPE;
882: l_vdr_cntct_name varchar2(25);
883: l_buyer_name po_buyers_v.full_name%TYPE;
884:
885: BEGIN

Line 901: FROM po_headers_all

897: l_po_num,
898: l_type_lookup_code,
899: l_vdr_cntct_id,
900: l_buyer_id
901: FROM po_headers_all
902: WHERE po_header_id = p_header_id;
903:
904: IF(l_type_lookup_code = 'STANDARD') THEN
905: l_doc_type := fnd_message.get_string('PO', 'PO_WF_NOTIF_STD_PO');

Line 926: FROM po_headers_all pha,

922: l_vdr_cntct_id,
923: l_buyer_id,
924: l_release_num,
925: l_type_lookup_code
926: FROM po_headers_all pha,
927: po_releases_all pra
928: WHERE pra.po_release_id = p_release_id
929: AND pra.po_header_id = pha.po_header_id;
930:

Line 2126: l_po_num po_headers_all.segment1%TYPE;

2122: IS
2123: l_api_name VARCHAR2(50) := 'Copy_Change';
2124: l_progress VARCHAR2(3) := '000';
2125: l_po_doc_type VARCHAR2(30);
2126: l_po_num po_headers_all.segment1%TYPE;
2127: l_po_revision_num NUMBER;
2128: l_po_line_id NUMBER;
2129: l_po_line_number NUMBER;
2130: l_po_line_location_id NUMBER;

Line 2243: po_headers_all pha,

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

Line 2324: po_headers_all pha,

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

Line 2413: po_headers_all pha,

2409: l_old_amount,
2410: l_old_curr_amount,
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,

Line 2496: po_headers_all pha,

2492: l_old_amount,
2493: l_old_curr_amount,
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,

Line 2936: po_headers_all pha,

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

Line 3169: FROM po_headers_all

3165:
3166: -- get org id of the PO
3167: SELECT org_id
3168: INTO l_po_org_id
3169: FROM po_headers_all
3170: WHERE po_header_id = l_po_header_id;
3171: ELSE
3172: l_po_doc_type := 'RELEASE';
3173: l_po_doc_subtype := 'BLANKET';

Line 3265: l_authorization_status po_headers_all.authorization_status%TYPE;

3261: l_source_type_code po_requisition_lines_all.source_type_code%TYPE;
3262: l_auction_display_number po_requisition_lines_all.auction_display_number%TYPE;
3263: l_auction_line_number NUMBER;
3264: l_reqs_in_pool_flag po_requisition_lines_all.reqs_in_pool_flag%TYPE;
3265: l_authorization_status po_headers_all.authorization_status%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;

Line 3267: l_closed_code po_headers_all.closed_code%TYPE;

3263: l_auction_line_number NUMBER;
3264: l_reqs_in_pool_flag po_requisition_lines_all.reqs_in_pool_flag%TYPE;
3265: l_authorization_status po_headers_all.authorization_status%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;

Line 3268: l_cancel_flag po_headers_all.cancel_flag%TYPE;

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

Line 3278: l_global_agreement_flag po_headers_all.global_agreement_flag%TYPE;

3274: l_count NUMBER;
3275: l_release_id NUMBER;
3276: l_return_status VARCHAR2(1);
3277: l_line_type po_line_types.purchase_basis%TYPE;
3278: l_global_agreement_flag po_headers_all.global_agreement_flag%TYPE;
3279: l_order_type_lookup_code po_requisition_lines_all.order_type_lookup_code%TYPE ;
3280: l_po_header_id po_headers_all.po_header_id%TYPE;
3281: l_template_id po_requisition_lines_all.noncat_template_id%TYPE;
3282: l_price_editable_flag por_noncat_templates_all_b.price_editable_flag%TYPE;

Line 3280: l_po_header_id po_headers_all.po_header_id%TYPE;

3276: l_return_status VARCHAR2(1);
3277: l_line_type po_line_types.purchase_basis%TYPE;
3278: l_global_agreement_flag po_headers_all.global_agreement_flag%TYPE;
3279: l_order_type_lookup_code po_requisition_lines_all.order_type_lookup_code%TYPE ;
3280: l_po_header_id po_headers_all.po_header_id%TYPE;
3281: l_template_id po_requisition_lines_all.noncat_template_id%TYPE;
3282: l_price_editable_flag por_noncat_templates_all_b.price_editable_flag%TYPE;
3283: l_amount_editable_flag por_noncat_templates_all_b.amount_editable_flag%TYPE;
3284: -- added for retroactive pricing checks

Line 3423: FROM po_headers_all pha,

3419: -- if there is not a backing GBPA, the labor anount can be changed
3420:
3421: SELECT pha.global_agreement_flag, pha.po_header_id
3422: INTO l_global_agreement_flag, l_po_header_id
3423: FROM po_headers_all pha,
3424: po_requisition_lines_all prla
3425: WHERE pha.po_header_id (+ ) = prla.blanket_po_header_id
3426: AND prla.requisition_line_id = p_req_line_id;
3427:

Line 3433: po_headers_all pha,

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

Line 3532: po_headers_all pha,

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

Line 3998: FROM po_headers_all

3994: WHERE line_location_id = l_line_loc_id;
3995: IF(l_po_release_id IS NULL) THEN
3996: SELECT revision_num, segment1 INTO
3997: l_po_revision_num, l_po_num
3998: FROM po_headers_all
3999: WHERE po_header_id = l_po_header_id;
4000:
4001: -- bug 5191164.
4002: -- Need to null out l_po_release_num for PO records

Line 4008: FROM po_headers_all

4004:
4005: ELSE
4006: -- get po_number of the source document for RELEASE
4007: SELECT segment1 INTO l_po_num
4008: FROM po_headers_all
4009: WHERE po_header_id = l_po_header_id;
4010:
4011: SELECT revision_num, release_num
4012: INTO l_po_revision_num, l_po_release_num

Line 4121: l_po_num po_headers_all.segment1%TYPE;

4117: l_req_dist_id NUMBER;
4118: l_req_line_id NUMBER;
4119: l_req_hdr_id NUMBER;
4120: l_req_num po_requisition_headers_all.segment1%TYPE;
4121: l_po_num po_headers_all.segment1%TYPE;
4122: l_header_id NUMBER;
4123: l_release_id NUMBER;
4124: l_line_id NUMBER;
4125: l_shipment_id NUMBER;

Line 4248: po_headers_all pha

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

Line 4265: po_headers_all pha

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

Line 4479: po_headers_all pha

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

Line 5452: from po_headers_all

5448: where line_location_id = l_line_loc_id;
5449: if(l_po_release_id is null) then
5450: select revision_num,segment1 into
5451: l_po_revision_num, l_po_num
5452: from po_headers_all
5453: where po_header_id = l_po_header_id;
5454:
5455: -- bug 5191164.
5456: -- Need to null out l_po_release_num for PO records

Line 5462: from po_headers_all

5458:
5459: else
5460: -- get po_number of the source document for RELEASE
5461: select segment1 into l_po_num
5462: from po_headers_all
5463: where po_header_id = l_po_header_id;
5464:
5465: select revision_num, release_num
5466: into l_po_revision_num, l_po_release_num