[Home] [Help]
1629: from pon_auction_headers_all paha,
1630: pon_emd_transactions petr,
1631: pon_bidding_parties pbp,
1632: fnd_lookup_values flv,
1633: HR_ALL_ORGANIZATION_UNITS_TL ou,
1634: pon_auc_doctypes doc,
1635: fnd_lookups f1,
1636: HZ_PARTIES hz
1637: where paha.auction_header_id = p_auction_header_id
2564: fnd_currencies_tl currency_tl ,
2565: pon_auc_doctypes doctypes,
2566: hz_parties hp1,
2567: hr_operating_units ou,
2568: hr_all_organization_units entity,
2569: hr_all_organization_units_tl entitytl,
2570: hr_locations_all entity_loc,
2571: fnd_territories_tl entity_terr,
2572: fnd_lookups fl_security,
2565: pon_auc_doctypes doctypes,
2566: hz_parties hp1,
2567: hr_operating_units ou,
2568: hr_all_organization_units entity,
2569: hr_all_organization_units_tl entitytl,
2570: hr_locations_all entity_loc,
2571: fnd_territories_tl entity_terr,
2572: fnd_lookups fl_security,
2573: gl_daily_conversion_types gdct,
2844: po_line_types_tl lt
2845: ,pa_projects_all proj
2846: ,pa_tasks_expend_v task
2847: ,gms_awards_all awrd
2848: ,hr_all_organization_units hrorg
2849: ,fnd_user fuser
2850: ,pon_bid_item_prices pbip
2851: where
2852: paip.auction_header_id = p_auction_header_id
2960: pa_projects_all proj,
2961: pa_tasks_expend_v task,
2962: gms_awards_all awrd,
2963: hr_locations_all hrl,
2964: hr_all_organization_units hrorg,
2965: fnd_user fuser,
2966: po_lookup_codes lkp1,
2967: fnd_territories_tl terr,
2968: mtl_units_of_measure_tl uom_tl
3035: pa_projects_all proj,
3036: pa_tasks_expend_v task,
3037: gms_awards_all awrd,
3038: hr_locations_all hrl,
3039: hr_all_organization_units hrorg,
3040: fnd_user fuser,
3041: po_lookup_codes lkp1,
3042: fnd_territories_tl terr,
3043: mtl_units_of_measure_tl uom_tl,
4141: loc.country country,
4142: loc.region_1 county
4143: from
4144: hr_locations_all loc,
4145: hr_all_organization_units haou,
4146: fnd_territories_tl ship_territories_tl,
4147: mtl_parameters mp ,
4148: ( SELECT
4149: distinct pas.ship_to_organization_id