1699: po_line_types_tl lt
1700: ,pa_projects_all proj
1701: ,pa_tasks task
1702: ,gms_awards_all awrd
1703: ,hr_all_organization_units hrorg
1704: ,fnd_user fuser
1705: ,pon_bid_item_prices pbip
1706: where
1707: paip.auction_header_id = pah.auction_header_id
2401: pa_projects_all proj,
2402: pa_tasks task,
2403: gms_awards_all awrd,
2404: hr_locations_all hrl,
2405: hr_all_organization_units hrorg,
2406: fnd_user fuser,
2407: po_lookup_codes lkp1,
2408: fnd_territories_tl terr,
2409: mtl_units_of_measure_tl uom_tl
2477: pa_projects_all proj,
2478: pa_tasks task,
2479: gms_awards_all awrd,
2480: hr_locations_all hrl,
2481: hr_all_organization_units hrorg,
2482: fnd_user fuser,
2483: po_lookup_codes lkp1,
2484: fnd_territories_tl terr,
2485: mtl_units_of_measure_tl uom_tl,
2555: loc.country country,
2556: loc.region_1 county
2557: from
2558: hr_locations_all loc,
2559: hr_all_organization_units haou,
2560: fnd_territories_tl ship_territories_tl,
2561: mtl_parameters mp ,
2562: ( SELECT
2563: distinct pas.ship_to_organization_id
3143: fnd_currencies_tl currency_tl ,
3144: pon_auc_doctypes doctypes,
3145: hz_parties hp1,
3146: hr_operating_units ou,
3147: hr_all_organization_units entity,
3148: hr_all_organization_units_tl entitytl,
3149: hr_locations_all entity_loc,
3150: fnd_territories_tl entity_terr,
3151: fnd_lookups fl_security,
3144: pon_auc_doctypes doctypes,
3145: hz_parties hp1,
3146: hr_operating_units ou,
3147: hr_all_organization_units entity,
3148: hr_all_organization_units_tl entitytl,
3149: hr_locations_all entity_loc,
3150: fnd_territories_tl entity_terr,
3151: fnd_lookups fl_security,
3152: gl_daily_conversion_types gdct,