DBA Data[Home] [Help]

APPS.PO_RETROACTIVE_PRICING_PVT dependencies on PO_TBL_NUMBER

Line 3557: l_po_header_ids_tbl po_tbl_number;

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;

Line 3558: l_po_release_ids_tbl po_tbl_number;

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;

Line 3559: l_from_header_ids_tbl po_tbl_number;

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;

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

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

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

Line 3566: l_organization_ids_tbl po_tbl_number;

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;

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

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

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

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

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

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

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

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

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

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