DBA Data[Home] [Help]

APPS.PO_RETROACTIVE_PRICING_PVT dependencies on PO_TBL_NUMBER

Line 3678: l_po_header_ids_tbl po_tbl_number;

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;

Line 3679: l_po_release_ids_tbl po_tbl_number;

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;

Line 3680: l_from_header_ids_tbl po_tbl_number;

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;

Line 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;

Line 3685: l_po_line_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;

Line 3686: l_inventory_item_ids_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;

Line 3687: l_organization_ids_tbl po_tbl_number;

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;

Line 3688: l_line_location_ids_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;

Line 3689: l_quantity_billeds_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;

Line 3691: l_new_prices_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;

Line 3692: l_old_prices_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;

Line 3693: l_transaction_quantitys_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;

Line 3694: l_transaction_costs_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;

Line 3695: l_distribution_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:

Line 3696: l_project_ids_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:
3700: l_primary_quantity PO_LINES.quantity%TYPE;

Line 3697: l_task_ids_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;
3701: l_primary_uom PO_LINES.unit_meas_lookup_code%TYPE;

Line 3698: l_dist_account_ids_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;
3702: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;