DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on PO_LINES_ALL

Line 2854: po_lines_all pol,

2850: -- notice: p_line_id and p_line_location_id uniquely identify a row.
2851: SELECT pcr.new_amount,(nvl(pll.quantity,0)-nvl(pll.quantity_cancelled,0)),pol.matching_basis
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')

Line 2942: po_lines_all pol

2938: l_blanket_header_id
2939: from
2940: po_requisition_lines_all prl,
2941: po_line_locations_all pll,
2942: po_lines_all pol
2943: where
2944: pol.po_line_id = p_line_id and
2945: pol.po_line_id = pll.po_line_id and
2946: prl.line_location_id = pll.line_location_id;

Line 3023: from po_lines_all pol

3019: /* bug 5363103 */
3020:
3021: select pol.po_header_id, pol.order_type_lookup_code
3022: into l_po_header_id, l_po_order_type
3023: from po_lines_all pol
3024: where pol.po_line_id = p_line_id;
3025:
3026: /* Removed code for dividing result by rate because now we have txn amt and txn price
3027: in PO_CHANGE_REQUESTs */

Line 3108: l_item_desc po_lines_all.item_description%TYPE;

3104: l_change_new_qty number;
3105: l_old_price number;
3106: l_new_price number;
3107: l_action_type po_change_requests.action_type%TYPE;
3108: l_item_desc po_lines_all.item_description%TYPE;
3109: l_uom po_line_locations_all.unit_meas_lookup_code%TYPE;
3110: l_line_quantity number;
3111: l_line_uom po_lines_all.unit_meas_lookup_code%TYPE;
3112: l_ship_to_location hr_locations_all.location_code%type;

Line 3111: l_line_uom po_lines_all.unit_meas_lookup_code%TYPE;

3107: l_action_type po_change_requests.action_type%TYPE;
3108: l_item_desc po_lines_all.item_description%TYPE;
3109: l_uom po_line_locations_all.unit_meas_lookup_code%TYPE;
3110: l_line_quantity number;
3111: l_line_uom po_lines_all.unit_meas_lookup_code%TYPE;
3112: l_ship_to_location hr_locations_all.location_code%type;
3113: l_request_reason po_change_requests.request_reason%type;
3114:
3115: l_old_quantity number;

Line 3128: l_po_line_id po_lines_all.po_line_id%TYPE;

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;
3132: l_supplier_item_num po_lines_all.VENDOR_PRODUCT_NUM%TYPE;

Line 3129: l_line_type_id po_lines_all.line_type_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;
3132: l_supplier_item_num po_lines_all.VENDOR_PRODUCT_NUM%TYPE;
3133: l_base_unit_price po_lines_all.base_unit_price%TYPE;

Line 3130: l_item_revision po_lines_all.item_revision%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;
3132: l_supplier_item_num po_lines_all.VENDOR_PRODUCT_NUM%TYPE;
3133: l_base_unit_price po_lines_all.base_unit_price%TYPE;
3134: l_pb_base_unit_price number;

Line 3131: l_category_id po_lines_all.category_id%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;
3132: l_supplier_item_num po_lines_all.VENDOR_PRODUCT_NUM%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;

Line 3132: l_supplier_item_num po_lines_all.VENDOR_PRODUCT_NUM%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;
3132: l_supplier_item_num po_lines_all.VENDOR_PRODUCT_NUM%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:

Line 3133: l_base_unit_price po_lines_all.base_unit_price%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;
3132: l_supplier_item_num po_lines_all.VENDOR_PRODUCT_NUM%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;

Line 3188: po_lines_all pol,

3184: pol.po_line_id, pcr.document_line_location_id,
3185: nvl(pcr.old_price, nvl(pll.price_override, pol.unit_price)),
3186: (nvl(pll.quantity,0)-nvl(pll.quantity_cancelled,0)))))
3187: from po_change_requests pcr,
3188: po_lines_all pol,
3189: po_line_locations_all pll,
3190: hr_locations_all hla
3191: where pcr.change_request_group_id=grp_id
3192: and pcr.request_status = 'PENDING'

Line 3236: from po_lines_all pol,

3232: nvl(pol.base_unit_price, pol.unit_price),
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

Line 3492: po_lines_all pol

3488: begin
3489: select count(1)
3490: into l_num_temp_labors
3491: from po_change_requests pcr,
3492: po_lines_all pol
3493: where pcr.change_request_group_id=l_grp_id
3494: and pcr.request_status = 'PENDING'
3495: and pcr.document_header_id=pol.po_header_id
3496: and pcr.document_line_id=pol.po_line_id

Line 3684: po_lines_all pol

3680: l_blanket_header_id, l_blanket_line_num
3681: from
3682: po_requisition_lines_all prl,
3683: po_line_locations_all pll,
3684: po_lines_all pol
3685: where
3686: pol.po_line_id = l_line_id and
3687: pol.po_line_id = pll.po_line_id and
3688: prl.line_location_id = pll.line_location_id;

Line 3884: l_po_line_id po_lines_all.po_line_id%TYPE;

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;
3888: l_supplier_item_num po_lines_all.VENDOR_PRODUCT_NUM%TYPE;

Line 3885: l_line_type_id po_lines_all.line_type_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;
3888: l_supplier_item_num po_lines_all.VENDOR_PRODUCT_NUM%TYPE;
3889: l_base_unit_price po_lines_all.base_unit_price%TYPE;

Line 3886: l_item_revision po_lines_all.item_revision%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;
3888: l_supplier_item_num po_lines_all.VENDOR_PRODUCT_NUM%TYPE;
3889: l_base_unit_price po_lines_all.base_unit_price%TYPE;
3890:

Line 3887: l_category_id po_lines_all.category_id%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;
3888: l_supplier_item_num po_lines_all.VENDOR_PRODUCT_NUM%TYPE;
3889: l_base_unit_price po_lines_all.base_unit_price%TYPE;
3890:
3891: l_action_type1 varchar2(30);

Line 3888: l_supplier_item_num po_lines_all.VENDOR_PRODUCT_NUM%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;
3888: l_supplier_item_num po_lines_all.VENDOR_PRODUCT_NUM%TYPE;
3889: l_base_unit_price po_lines_all.base_unit_price%TYPE;
3890:
3891: l_action_type1 varchar2(30);
3892: l_blanket_header_id number;

Line 3889: l_base_unit_price po_lines_all.base_unit_price%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;
3888: l_supplier_item_num po_lines_all.VENDOR_PRODUCT_NUM%TYPE;
3889: l_base_unit_price po_lines_all.base_unit_price%TYPE;
3890:
3891: l_action_type1 varchar2(30);
3892: l_blanket_header_id number;
3893: l_blanket_line_id number;

Line 3967: from po_lines_all pol,

3963: nvl(pll.accrue_on_receipt_flag,'N'),
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

Line 4183: FROM po_lines_all pol,

4179: l_price_break_type,
4180: l_quantity_received,
4181: l_accrue_on_receipt_flag,
4182: l_quantity_billed
4183: FROM po_lines_all pol,
4184: po_line_locations_all pll,
4185: po_change_requests pcr
4186: WHERE pcr.change_request_group_id = p_group_id
4187: and pll.line_location_id = p_line_location_id

Line 4313: po_lines_all pol

4309: select distinct prl.blanket_po_header_id
4310: into l_blanket_po_header_id
4311: from po_requisition_lines_all prl,
4312: po_line_locations_all pll,
4313: po_lines_all pol
4314: where pol.po_line_id = p_line_id
4315: and pol.po_line_id = pll.po_line_id
4316: and prl.line_location_id = pll.line_location_id
4317: and pll.line_location_id = p_line_location_id;

Line 4342: po_lines_all pol,

4338:
4339: select pcr.old_price, nvl(pcr.old_price,nvl(pll.price_override, pol.unit_price))
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')

Line 4359: po_lines_all pol,

4355: else
4356: select pcr.old_price, pol.unit_price,nvl(pcr.old_price,nvl(pll.price_override, pol.unit_price))
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')

Line 4387: from po_lines_all pol

4383: */
4384:
4385: select pol.po_header_id, pol.matching_basis,pol.order_type_lookup_code
4386: into l_po_header_id, l_po_matching_basis,l_po_order_type
4387: from po_lines_all pol
4388: where pol.po_line_id = p_line_id;
4389:
4390: /* Removed code for dividing result by rate because now we have txn amt and txn price
4391: in PO_CHANGE_REQUESTs */