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_REQCHANGEREQUESTNOTIF_PVT dependencies on PO_HEADERS_ALL

Line 2190: PO_HEADERS_ALL PH, --

2186: SELECT PH.SEGMENT1|| DECODE(PR.RELEASE_NUM, NULL, '', '-' || PR.RELEASE_NUM)
2187: INTO l_po_num
2188: FROM
2189: PO_RELEASES PR,
2190: PO_HEADERS_ALL PH, --
2191: PO_LINE_LOCATIONS PLL
2192: WHERE
2193: pll.line_location_id=p_line_location_id and
2194: PLL.PO_HEADER_ID = PH.PO_HEADER_ID AND

Line 2856: po_headers_all poh

2852: into l_tmp_new_amount, l_old_quantity,l_matching_basis
2853: FROM po_change_requests pcr,
2854: po_lines_all pol,
2855: po_line_locations_all pll,
2856: po_headers_all poh
2857: WHERE pcr.change_request_group_id= p_group_id
2858: AND pcr.request_status IN ('PENDING', 'BUYER_APP', 'ACCEPTED', 'REJECTED')
2859: AND pol.po_line_id = p_line_id
2860: AND pll.line_location_id = p_line_location_id

Line 3084: l_fob po_headers_all.fob_lookup_code%TYPE;

3080: l_sup_city po_vendor_sites_all.city%TYPE;
3081: l_sup_state po_vendor_sites_all.state%TYPE;
3082: l_sup_zip po_vendor_sites_all.zip%TYPE;
3083: l_order_date date;
3084: l_fob po_headers_all.fob_lookup_code%TYPE;
3085: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
3086: l_ship_to_id number;
3087: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3088: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;

Line 3085: l_carrier po_headers_all.ship_via_lookup_code%TYPE;

3081: l_sup_state po_vendor_sites_all.state%TYPE;
3082: l_sup_zip po_vendor_sites_all.zip%TYPE;
3083: l_order_date date;
3084: l_fob po_headers_all.fob_lookup_code%TYPE;
3085: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
3086: l_ship_to_id number;
3087: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3088: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3089: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;

Line 3124: l_supplier_id po_headers_all.vendor_id%TYPE;

3120: l_line_id number:=null;
3121: l_pre_line_id number:=null;
3122: l_pb_new_price number;
3123:
3124: l_supplier_id po_headers_all.vendor_id%TYPE;
3125: l_supplier_site_id po_headers_all.vendor_site_id%TYPE;
3126: l_creation_date po_headers_all.creation_date%TYPE;
3127: l_po_header_id po_headers_all.po_header_id%TYPE;
3128: l_po_line_id po_lines_all.po_line_id%TYPE;

Line 3125: l_supplier_site_id po_headers_all.vendor_site_id%TYPE;

3121: l_pre_line_id number:=null;
3122: l_pb_new_price number;
3123:
3124: l_supplier_id po_headers_all.vendor_id%TYPE;
3125: l_supplier_site_id po_headers_all.vendor_site_id%TYPE;
3126: l_creation_date po_headers_all.creation_date%TYPE;
3127: l_po_header_id po_headers_all.po_header_id%TYPE;
3128: l_po_line_id po_lines_all.po_line_id%TYPE;
3129: l_line_type_id po_lines_all.line_type_id%TYPE;

Line 3126: l_creation_date po_headers_all.creation_date%TYPE;

3122: l_pb_new_price number;
3123:
3124: l_supplier_id po_headers_all.vendor_id%TYPE;
3125: l_supplier_site_id po_headers_all.vendor_site_id%TYPE;
3126: l_creation_date po_headers_all.creation_date%TYPE;
3127: l_po_header_id po_headers_all.po_header_id%TYPE;
3128: l_po_line_id po_lines_all.po_line_id%TYPE;
3129: l_line_type_id po_lines_all.line_type_id%TYPE;
3130: l_item_revision po_lines_all.item_revision%TYPE;

Line 3127: l_po_header_id po_headers_all.po_header_id%TYPE;

3123:
3124: l_supplier_id po_headers_all.vendor_id%TYPE;
3125: l_supplier_site_id po_headers_all.vendor_site_id%TYPE;
3126: l_creation_date po_headers_all.creation_date%TYPE;
3127: l_po_header_id po_headers_all.po_header_id%TYPE;
3128: l_po_line_id po_lines_all.po_line_id%TYPE;
3129: l_line_type_id po_lines_all.line_type_id%TYPE;
3130: l_item_revision po_lines_all.item_revision%TYPE;
3131: l_category_id po_lines_all.category_id%TYPE;

Line 3137: l_global_flag po_headers_all.global_agreement_flag%type;

3133: l_base_unit_price po_lines_all.base_unit_price%TYPE;
3134: l_pb_base_unit_price number;
3135: l_pb_break_id number;
3136:
3137: l_global_flag po_headers_all.global_agreement_flag%type;
3138:
3139: --difference in Get_Po_Chg_Approval_Notif
3140:
3141: -- fix bug 2733542

Line 3237: po_headers_all poh,

3233: nvl(pll.quantity_received,0),
3234: nvl(pll.accrue_on_receipt_flag,'N'),
3235: nvl(pll.quantity_billed,0)
3236: from po_lines_all pol,
3237: po_headers_all poh,
3238: po_line_locations_all pll,
3239: po_change_requests pcr
3240: where pol.po_line_id=line_id
3241: and pol.po_header_id=poh.po_header_id

Line 3253: l_currency_code po_headers_all.currency_code%type;

3249: l_blanket_line_id number;
3250: l_blanket_line_num number;
3251: l_line_total_qty number;
3252: l_ship_to_loc_id number;
3253: l_currency_code po_headers_all.currency_code%type;
3254: l_rate_type po_headers_all.rate_type%type;
3255: l_ship_need_by DATE;
3256: l_pb_new_curr_price number;
3257: l_pb_discount number;

Line 3254: l_rate_type po_headers_all.rate_type%type;

3250: l_blanket_line_num number;
3251: l_line_total_qty number;
3252: l_ship_to_loc_id number;
3253: l_currency_code po_headers_all.currency_code%type;
3254: l_rate_type po_headers_all.rate_type%type;
3255: l_ship_need_by DATE;
3256: l_pb_new_curr_price number;
3257: l_pb_discount number;
3258: l_pb_currency_code po_headers_all.currency_code%type;

Line 3258: l_pb_currency_code po_headers_all.currency_code%type;

3254: l_rate_type po_headers_all.rate_type%type;
3255: l_ship_need_by DATE;
3256: l_pb_new_curr_price number;
3257: l_pb_discount number;
3258: l_pb_currency_code po_headers_all.currency_code%type;
3259: l_pb_rate_type po_headers_all.rate_type%type;
3260: l_pb_rate_date date;
3261: l_pb_rate number;
3262:

Line 3259: l_pb_rate_type po_headers_all.rate_type%type;

3255: l_ship_need_by DATE;
3256: l_pb_new_curr_price number;
3257: l_pb_discount number;
3258: l_pb_currency_code po_headers_all.currency_code%type;
3259: l_pb_rate_type po_headers_all.rate_type%type;
3260: l_pb_rate_date date;
3261: l_pb_rate number;
3262:
3263: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

Line 3316: from po_headers_all

3312: into
3313: l_po_num, l_revision_num, l_po_total, l_po_currency,
3314: l_vendor_id,l_vendor_site_id,l_order_date, l_fob,
3315: l_carrier, l_ship_to_id, l_acceptance_required_flag,l_type_lookup_code
3316: from po_headers_all
3317: where po_header_id = l_header_id;
3318:
3319: if(l_type_lookup_code = 'STANDARD') then
3320: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');

Line 3343: from po_releases_all pr, po_headers_all ph

3339: into
3340: l_blanket_num, l_release_num, l_revision_num, l_po_total, l_po_currency,
3341: l_vendor_id,l_vendor_site_id,l_order_date, l_fob,
3342: l_carrier, l_ship_to_id, l_acceptance_required_flag,l_type_lookup_code
3343: from po_releases_all pr, po_headers_all ph
3344: where pr.po_release_id = l_release_id
3345: and pr.po_header_id = ph.po_header_id;
3346:
3347: if(l_type_lookup_code = 'BLANKET') then

Line 3880: l_supplier_id po_headers_all.vendor_id%TYPE;

3876: p_old_price in number,
3877: p_line_location_id in number) RETURN number
3878: IS
3879:
3880: l_supplier_id po_headers_all.vendor_id%TYPE;
3881: l_supplier_site_id po_headers_all.vendor_site_id%TYPE;
3882: l_creation_date po_headers_all.creation_date%TYPE;
3883: l_po_header_id po_headers_all.po_header_id%TYPE;
3884: l_po_line_id po_lines_all.po_line_id%TYPE;

Line 3881: l_supplier_site_id po_headers_all.vendor_site_id%TYPE;

3877: p_line_location_id in number) RETURN number
3878: IS
3879:
3880: l_supplier_id po_headers_all.vendor_id%TYPE;
3881: l_supplier_site_id po_headers_all.vendor_site_id%TYPE;
3882: l_creation_date po_headers_all.creation_date%TYPE;
3883: l_po_header_id po_headers_all.po_header_id%TYPE;
3884: l_po_line_id po_lines_all.po_line_id%TYPE;
3885: l_line_type_id po_lines_all.line_type_id%TYPE;

Line 3882: l_creation_date po_headers_all.creation_date%TYPE;

3878: IS
3879:
3880: l_supplier_id po_headers_all.vendor_id%TYPE;
3881: l_supplier_site_id po_headers_all.vendor_site_id%TYPE;
3882: l_creation_date po_headers_all.creation_date%TYPE;
3883: l_po_header_id po_headers_all.po_header_id%TYPE;
3884: l_po_line_id po_lines_all.po_line_id%TYPE;
3885: l_line_type_id po_lines_all.line_type_id%TYPE;
3886: l_item_revision po_lines_all.item_revision%TYPE;

Line 3883: l_po_header_id po_headers_all.po_header_id%TYPE;

3879:
3880: l_supplier_id po_headers_all.vendor_id%TYPE;
3881: l_supplier_site_id po_headers_all.vendor_site_id%TYPE;
3882: l_creation_date po_headers_all.creation_date%TYPE;
3883: l_po_header_id po_headers_all.po_header_id%TYPE;
3884: l_po_line_id po_lines_all.po_line_id%TYPE;
3885: l_line_type_id po_lines_all.line_type_id%TYPE;
3886: l_item_revision po_lines_all.item_revision%TYPE;
3887: l_category_id po_lines_all.category_id%TYPE;

Line 3897: l_currency_code po_headers_all.currency_code%type;

3893: l_blanket_line_id number;
3894: l_blanket_line_num number;
3895: l_line_total_qty number;
3896: l_ship_to_loc_id number;
3897: l_currency_code po_headers_all.currency_code%type;
3898: l_rate_type po_headers_all.rate_type%type;
3899: l_ship_need_by DATE;
3900: l_pb_new_curr_price number;
3901: l_pb_discount number;

Line 3898: l_rate_type po_headers_all.rate_type%type;

3894: l_blanket_line_num number;
3895: l_line_total_qty number;
3896: l_ship_to_loc_id number;
3897: l_currency_code po_headers_all.currency_code%type;
3898: l_rate_type po_headers_all.rate_type%type;
3899: l_ship_need_by DATE;
3900: l_pb_new_curr_price number;
3901: l_pb_discount number;
3902: l_pb_currency_code po_headers_all.currency_code%type;

Line 3902: l_pb_currency_code po_headers_all.currency_code%type;

3898: l_rate_type po_headers_all.rate_type%type;
3899: l_ship_need_by DATE;
3900: l_pb_new_curr_price number;
3901: l_pb_discount number;
3902: l_pb_currency_code po_headers_all.currency_code%type;
3903: l_pb_rate_type po_headers_all.rate_type%type;
3904: l_pb_rate_date date;
3905: l_pb_rate number;
3906: l_pb_base_unit_price number;

Line 3903: l_pb_rate_type po_headers_all.rate_type%type;

3899: l_ship_need_by DATE;
3900: l_pb_new_curr_price number;
3901: l_pb_discount number;
3902: l_pb_currency_code po_headers_all.currency_code%type;
3903: l_pb_rate_type po_headers_all.rate_type%type;
3904: l_pb_rate_date date;
3905: l_pb_rate number;
3906: l_pb_base_unit_price number;
3907: l_pb_break_id number;

Line 3968: po_headers_all poh,

3964: nvl(pll.quantity_billed,0),
3965: pol.from_line_id,
3966: pol.contract_id
3967: from po_lines_all pol,
3968: po_headers_all poh,
3969: po_line_locations_all pll,
3970: po_change_requests pcr
3971: where pol.po_line_id=line_id
3972: and pol.po_header_id=poh.po_header_id

Line 4344: po_headers_all poh

4340: into l_pcr_old_price, l_price
4341: FROM po_change_requests pcr,
4342: po_lines_all pol,
4343: po_line_locations_all pll,
4344: po_headers_all poh
4345: WHERE pcr.change_request_group_id= p_group_id
4346: AND pcr.request_status IN ('PENDING', 'BUYER_APP', 'ACCEPTED', 'REJECTED')
4347: AND pol.po_line_id = p_line_id
4348: AND pll.line_location_id is null

Line 4361: po_headers_all poh

4357: into l_pcr_old_price,l_pol_unit_price,l_price
4358: FROM po_change_requests pcr,
4359: po_lines_all pol,
4360: po_line_locations_all pll,
4361: po_headers_all poh
4362: WHERE pcr.change_request_group_id= p_group_id
4363: AND pcr.request_status IN ('PENDING', 'BUYER_APP', 'ACCEPTED', 'REJECTED')
4364: AND pol.po_line_id = p_line_id
4365: AND pll.line_location_id = p_line_location_id

Line 4470: from po_headers_all poh

4466: l_progress := '003';
4467:
4468: select poh.currency_code,poh.rate
4469: into l_po_currency_code,l_rate
4470: from po_headers_all poh
4471: where poh.po_header_id = p_po_header_id;
4472:
4473: if (l_functional_currency_code <> l_po_currency_code ) then
4474: x_po_in_txn_currency:= 'Y';