3553: AND poda.latest_external_flag = 'Y'
3554: AND poll.price_override <> polla.price_override; -- Bug 3526448
3555:
3556:
3557: l_po_header_ids_tbl po_tbl_number;
3558: l_po_release_ids_tbl po_tbl_number;
3559: l_from_header_ids_tbl po_tbl_number;
3560: l_currency_codes_tbl po_tbl_varchar30;
3561: l_rate_types_tbl po_tbl_varchar30;
3554: AND poll.price_override <> polla.price_override; -- Bug 3526448
3555:
3556:
3557: l_po_header_ids_tbl po_tbl_number;
3558: l_po_release_ids_tbl po_tbl_number;
3559: l_from_header_ids_tbl po_tbl_number;
3560: l_currency_codes_tbl po_tbl_varchar30;
3561: l_rate_types_tbl po_tbl_varchar30;
3562: l_rate_dates_tbl po_tbl_date;
3555:
3556:
3557: l_po_header_ids_tbl po_tbl_number;
3558: l_po_release_ids_tbl po_tbl_number;
3559: l_from_header_ids_tbl po_tbl_number;
3560: l_currency_codes_tbl po_tbl_varchar30;
3561: l_rate_types_tbl po_tbl_varchar30;
3562: l_rate_dates_tbl po_tbl_date;
3563: l_rates_tbl po_tbl_number;
3559: l_from_header_ids_tbl po_tbl_number;
3560: l_currency_codes_tbl po_tbl_varchar30;
3561: l_rate_types_tbl po_tbl_varchar30;
3562: l_rate_dates_tbl po_tbl_date;
3563: l_rates_tbl po_tbl_number;
3564: l_po_line_ids_tbl po_tbl_number;
3565: l_inventory_item_ids_tbl po_tbl_number;
3566: l_organization_ids_tbl po_tbl_number;
3567: l_line_location_ids_tbl po_tbl_number;
3560: l_currency_codes_tbl po_tbl_varchar30;
3561: l_rate_types_tbl po_tbl_varchar30;
3562: l_rate_dates_tbl po_tbl_date;
3563: l_rates_tbl po_tbl_number;
3564: l_po_line_ids_tbl po_tbl_number;
3565: l_inventory_item_ids_tbl po_tbl_number;
3566: l_organization_ids_tbl po_tbl_number;
3567: l_line_location_ids_tbl po_tbl_number;
3568: l_quantity_billeds_tbl po_tbl_number;
3561: l_rate_types_tbl po_tbl_varchar30;
3562: l_rate_dates_tbl po_tbl_date;
3563: l_rates_tbl po_tbl_number;
3564: l_po_line_ids_tbl po_tbl_number;
3565: l_inventory_item_ids_tbl po_tbl_number;
3566: l_organization_ids_tbl po_tbl_number;
3567: l_line_location_ids_tbl po_tbl_number;
3568: l_quantity_billeds_tbl po_tbl_number;
3569: l_transaction_uoms_tbl po_tbl_varchar30;
3562: l_rate_dates_tbl po_tbl_date;
3563: l_rates_tbl po_tbl_number;
3564: l_po_line_ids_tbl po_tbl_number;
3565: l_inventory_item_ids_tbl po_tbl_number;
3566: l_organization_ids_tbl po_tbl_number;
3567: l_line_location_ids_tbl po_tbl_number;
3568: l_quantity_billeds_tbl po_tbl_number;
3569: l_transaction_uoms_tbl po_tbl_varchar30;
3570: l_new_prices_tbl po_tbl_number;
3563: l_rates_tbl po_tbl_number;
3564: l_po_line_ids_tbl po_tbl_number;
3565: l_inventory_item_ids_tbl po_tbl_number;
3566: l_organization_ids_tbl po_tbl_number;
3567: l_line_location_ids_tbl po_tbl_number;
3568: l_quantity_billeds_tbl po_tbl_number;
3569: l_transaction_uoms_tbl po_tbl_varchar30;
3570: l_new_prices_tbl po_tbl_number;
3571: l_old_prices_tbl po_tbl_number;
3564: l_po_line_ids_tbl po_tbl_number;
3565: l_inventory_item_ids_tbl po_tbl_number;
3566: l_organization_ids_tbl po_tbl_number;
3567: l_line_location_ids_tbl po_tbl_number;
3568: l_quantity_billeds_tbl po_tbl_number;
3569: l_transaction_uoms_tbl po_tbl_varchar30;
3570: l_new_prices_tbl po_tbl_number;
3571: l_old_prices_tbl po_tbl_number;
3572: l_transaction_quantitys_tbl po_tbl_number;
3566: l_organization_ids_tbl po_tbl_number;
3567: l_line_location_ids_tbl po_tbl_number;
3568: l_quantity_billeds_tbl po_tbl_number;
3569: l_transaction_uoms_tbl po_tbl_varchar30;
3570: l_new_prices_tbl po_tbl_number;
3571: l_old_prices_tbl po_tbl_number;
3572: l_transaction_quantitys_tbl po_tbl_number;
3573: l_transaction_costs_tbl po_tbl_number;
3574: l_distribution_ids_tbl po_tbl_number;
3567: l_line_location_ids_tbl po_tbl_number;
3568: l_quantity_billeds_tbl po_tbl_number;
3569: l_transaction_uoms_tbl po_tbl_varchar30;
3570: l_new_prices_tbl po_tbl_number;
3571: l_old_prices_tbl po_tbl_number;
3572: l_transaction_quantitys_tbl po_tbl_number;
3573: l_transaction_costs_tbl po_tbl_number;
3574: l_distribution_ids_tbl po_tbl_number;
3575: l_project_ids_tbl po_tbl_number;
3568: l_quantity_billeds_tbl po_tbl_number;
3569: l_transaction_uoms_tbl po_tbl_varchar30;
3570: l_new_prices_tbl po_tbl_number;
3571: l_old_prices_tbl po_tbl_number;
3572: l_transaction_quantitys_tbl po_tbl_number;
3573: l_transaction_costs_tbl po_tbl_number;
3574: l_distribution_ids_tbl po_tbl_number;
3575: l_project_ids_tbl po_tbl_number;
3576: l_task_ids_tbl po_tbl_number;
3569: l_transaction_uoms_tbl po_tbl_varchar30;
3570: l_new_prices_tbl po_tbl_number;
3571: l_old_prices_tbl po_tbl_number;
3572: l_transaction_quantitys_tbl po_tbl_number;
3573: l_transaction_costs_tbl po_tbl_number;
3574: l_distribution_ids_tbl po_tbl_number;
3575: l_project_ids_tbl po_tbl_number;
3576: l_task_ids_tbl po_tbl_number;
3577: l_dist_account_ids_tbl po_tbl_number;
3570: l_new_prices_tbl po_tbl_number;
3571: l_old_prices_tbl po_tbl_number;
3572: l_transaction_quantitys_tbl po_tbl_number;
3573: l_transaction_costs_tbl po_tbl_number;
3574: l_distribution_ids_tbl po_tbl_number;
3575: l_project_ids_tbl po_tbl_number;
3576: l_task_ids_tbl po_tbl_number;
3577: l_dist_account_ids_tbl po_tbl_number;
3578:
3571: l_old_prices_tbl po_tbl_number;
3572: l_transaction_quantitys_tbl po_tbl_number;
3573: l_transaction_costs_tbl po_tbl_number;
3574: l_distribution_ids_tbl po_tbl_number;
3575: l_project_ids_tbl po_tbl_number;
3576: l_task_ids_tbl po_tbl_number;
3577: l_dist_account_ids_tbl po_tbl_number;
3578:
3579: l_primary_quantity PO_LINES.quantity%TYPE;
3572: l_transaction_quantitys_tbl po_tbl_number;
3573: l_transaction_costs_tbl po_tbl_number;
3574: l_distribution_ids_tbl po_tbl_number;
3575: l_project_ids_tbl po_tbl_number;
3576: l_task_ids_tbl po_tbl_number;
3577: l_dist_account_ids_tbl po_tbl_number;
3578:
3579: l_primary_quantity PO_LINES.quantity%TYPE;
3580: l_primary_uom PO_LINES.unit_meas_lookup_code%TYPE;
3573: l_transaction_costs_tbl po_tbl_number;
3574: l_distribution_ids_tbl po_tbl_number;
3575: l_project_ids_tbl po_tbl_number;
3576: l_task_ids_tbl po_tbl_number;
3577: l_dist_account_ids_tbl po_tbl_number;
3578:
3579: l_primary_quantity PO_LINES.quantity%TYPE;
3580: l_primary_uom PO_LINES.unit_meas_lookup_code%TYPE;
3581: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;