1226: p_ECE_TP_LOCATION_CODE, p_ADDRESS_LINE_1, p_ADDRESS_LINE_2,
1227: p_ADDRESS_LINE_3, p_TOWN_OR_CITY, p_COUNTRY,
1228: p_POSTAL_CODE, p_STATE, p_TELEPHONE_NUMBER_1,
1229: p_TELEPHONE_NUMBER_2, p_TELEPHONE_NUMBER_3
1230: from HZ_LOCATIONS HZA
1231: where HZA.LOCATION_ID = p_ship_to_location_id;
1232:
1233: /* it is not drop ship */
1234:
1294: p_ECE_TP_LOCATION_CODE, p_ADDRESS_LINE_1, p_ADDRESS_LINE_2,
1295: p_ADDRESS_LINE_3, p_TOWN_OR_CITY, p_COUNTRY,
1296: p_POSTAL_CODE, p_STATE, p_TELEPHONE_NUMBER_1,
1297: p_TELEPHONE_NUMBER_2, p_TELEPHONE_NUMBER_3
1298: from HZ_LOCATIONS HZA
1299: where HZA.LOCATION_ID = p_ship_to_location_id;
1300:
1301: /* it is not drop ship */
1302: else
1871: x_city,
1872: x_postalcode,
1873: x_country,
1874: x_stateprovn
1875: FROM hz_locations hzl
1876: where HzL.location_id = l_location_id;
1877: /*
1878: in case of drop ship no ece_tp_location_code?, telphone nubmers.
1879: */