3674: AND poda.latest_external_flag = 'Y'
3675: AND poll.price_override <> polla.price_override; -- Bug 3526448
3676:
3677:
3678: l_po_header_ids_tbl po_tbl_number;
3679: l_po_release_ids_tbl po_tbl_number;
3680: l_from_header_ids_tbl po_tbl_number;
3681: l_currency_codes_tbl po_tbl_varchar30;
3682: l_rate_types_tbl po_tbl_varchar30;
3675: AND poll.price_override <> polla.price_override; -- Bug 3526448
3676:
3677:
3678: l_po_header_ids_tbl po_tbl_number;
3679: l_po_release_ids_tbl po_tbl_number;
3680: l_from_header_ids_tbl po_tbl_number;
3681: l_currency_codes_tbl po_tbl_varchar30;
3682: l_rate_types_tbl po_tbl_varchar30;
3683: l_rate_dates_tbl po_tbl_date;
3676:
3677:
3678: l_po_header_ids_tbl po_tbl_number;
3679: l_po_release_ids_tbl po_tbl_number;
3680: l_from_header_ids_tbl po_tbl_number;
3681: l_currency_codes_tbl po_tbl_varchar30;
3682: l_rate_types_tbl po_tbl_varchar30;
3683: l_rate_dates_tbl po_tbl_date;
3684: l_rates_tbl po_tbl_number;
3680: l_from_header_ids_tbl po_tbl_number;
3681: l_currency_codes_tbl po_tbl_varchar30;
3682: l_rate_types_tbl po_tbl_varchar30;
3683: l_rate_dates_tbl po_tbl_date;
3684: l_rates_tbl po_tbl_number;
3685: l_po_line_ids_tbl po_tbl_number;
3686: l_inventory_item_ids_tbl po_tbl_number;
3687: l_organization_ids_tbl po_tbl_number;
3688: l_line_location_ids_tbl po_tbl_number;
3681: l_currency_codes_tbl po_tbl_varchar30;
3682: l_rate_types_tbl po_tbl_varchar30;
3683: l_rate_dates_tbl po_tbl_date;
3684: l_rates_tbl po_tbl_number;
3685: l_po_line_ids_tbl po_tbl_number;
3686: l_inventory_item_ids_tbl po_tbl_number;
3687: l_organization_ids_tbl po_tbl_number;
3688: l_line_location_ids_tbl po_tbl_number;
3689: l_quantity_billeds_tbl po_tbl_number;
3682: l_rate_types_tbl po_tbl_varchar30;
3683: l_rate_dates_tbl po_tbl_date;
3684: l_rates_tbl po_tbl_number;
3685: l_po_line_ids_tbl po_tbl_number;
3686: l_inventory_item_ids_tbl po_tbl_number;
3687: l_organization_ids_tbl po_tbl_number;
3688: l_line_location_ids_tbl po_tbl_number;
3689: l_quantity_billeds_tbl po_tbl_number;
3690: l_transaction_uoms_tbl po_tbl_varchar30;
3683: l_rate_dates_tbl po_tbl_date;
3684: l_rates_tbl po_tbl_number;
3685: l_po_line_ids_tbl po_tbl_number;
3686: l_inventory_item_ids_tbl po_tbl_number;
3687: l_organization_ids_tbl po_tbl_number;
3688: l_line_location_ids_tbl po_tbl_number;
3689: l_quantity_billeds_tbl po_tbl_number;
3690: l_transaction_uoms_tbl po_tbl_varchar30;
3691: l_new_prices_tbl po_tbl_number;
3684: l_rates_tbl po_tbl_number;
3685: l_po_line_ids_tbl po_tbl_number;
3686: l_inventory_item_ids_tbl po_tbl_number;
3687: l_organization_ids_tbl po_tbl_number;
3688: l_line_location_ids_tbl po_tbl_number;
3689: l_quantity_billeds_tbl po_tbl_number;
3690: l_transaction_uoms_tbl po_tbl_varchar30;
3691: l_new_prices_tbl po_tbl_number;
3692: l_old_prices_tbl po_tbl_number;
3685: l_po_line_ids_tbl po_tbl_number;
3686: l_inventory_item_ids_tbl po_tbl_number;
3687: l_organization_ids_tbl po_tbl_number;
3688: l_line_location_ids_tbl po_tbl_number;
3689: l_quantity_billeds_tbl po_tbl_number;
3690: l_transaction_uoms_tbl po_tbl_varchar30;
3691: l_new_prices_tbl po_tbl_number;
3692: l_old_prices_tbl po_tbl_number;
3693: l_transaction_quantitys_tbl po_tbl_number;
3687: l_organization_ids_tbl po_tbl_number;
3688: l_line_location_ids_tbl po_tbl_number;
3689: l_quantity_billeds_tbl po_tbl_number;
3690: l_transaction_uoms_tbl po_tbl_varchar30;
3691: l_new_prices_tbl po_tbl_number;
3692: l_old_prices_tbl po_tbl_number;
3693: l_transaction_quantitys_tbl po_tbl_number;
3694: l_transaction_costs_tbl po_tbl_number;
3695: l_distribution_ids_tbl po_tbl_number;
3688: l_line_location_ids_tbl po_tbl_number;
3689: l_quantity_billeds_tbl po_tbl_number;
3690: l_transaction_uoms_tbl po_tbl_varchar30;
3691: l_new_prices_tbl po_tbl_number;
3692: l_old_prices_tbl po_tbl_number;
3693: l_transaction_quantitys_tbl po_tbl_number;
3694: l_transaction_costs_tbl po_tbl_number;
3695: l_distribution_ids_tbl po_tbl_number;
3696: l_project_ids_tbl po_tbl_number;
3689: l_quantity_billeds_tbl po_tbl_number;
3690: l_transaction_uoms_tbl po_tbl_varchar30;
3691: l_new_prices_tbl po_tbl_number;
3692: l_old_prices_tbl po_tbl_number;
3693: l_transaction_quantitys_tbl po_tbl_number;
3694: l_transaction_costs_tbl po_tbl_number;
3695: l_distribution_ids_tbl po_tbl_number;
3696: l_project_ids_tbl po_tbl_number;
3697: l_task_ids_tbl po_tbl_number;
3690: l_transaction_uoms_tbl po_tbl_varchar30;
3691: l_new_prices_tbl po_tbl_number;
3692: l_old_prices_tbl po_tbl_number;
3693: l_transaction_quantitys_tbl po_tbl_number;
3694: l_transaction_costs_tbl po_tbl_number;
3695: l_distribution_ids_tbl po_tbl_number;
3696: l_project_ids_tbl po_tbl_number;
3697: l_task_ids_tbl po_tbl_number;
3698: l_dist_account_ids_tbl po_tbl_number;
3691: l_new_prices_tbl po_tbl_number;
3692: l_old_prices_tbl po_tbl_number;
3693: l_transaction_quantitys_tbl po_tbl_number;
3694: l_transaction_costs_tbl po_tbl_number;
3695: l_distribution_ids_tbl po_tbl_number;
3696: l_project_ids_tbl po_tbl_number;
3697: l_task_ids_tbl po_tbl_number;
3698: l_dist_account_ids_tbl po_tbl_number;
3699:
3692: l_old_prices_tbl po_tbl_number;
3693: l_transaction_quantitys_tbl po_tbl_number;
3694: l_transaction_costs_tbl po_tbl_number;
3695: l_distribution_ids_tbl po_tbl_number;
3696: l_project_ids_tbl po_tbl_number;
3697: l_task_ids_tbl po_tbl_number;
3698: l_dist_account_ids_tbl po_tbl_number;
3699:
3700: l_primary_quantity PO_LINES.quantity%TYPE;
3693: l_transaction_quantitys_tbl po_tbl_number;
3694: l_transaction_costs_tbl po_tbl_number;
3695: l_distribution_ids_tbl po_tbl_number;
3696: l_project_ids_tbl po_tbl_number;
3697: l_task_ids_tbl po_tbl_number;
3698: l_dist_account_ids_tbl po_tbl_number;
3699:
3700: l_primary_quantity PO_LINES.quantity%TYPE;
3701: l_primary_uom PO_LINES.unit_meas_lookup_code%TYPE;
3694: l_transaction_costs_tbl po_tbl_number;
3695: l_distribution_ids_tbl po_tbl_number;
3696: l_project_ids_tbl po_tbl_number;
3697: l_task_ids_tbl po_tbl_number;
3698: l_dist_account_ids_tbl po_tbl_number;
3699:
3700: l_primary_quantity PO_LINES.quantity%TYPE;
3701: l_primary_uom PO_LINES.unit_meas_lookup_code%TYPE;
3702: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;