APPS.PO_XML_DELIVERY dependencies on HZ_LOCATIONS

Line 1233: from HZ_LOCATIONS HZA

1229: p_ECE_TP_LOCATION_CODE, P_SHIP_TO_LOCATION_CODE, p_ADDRESS_LINE_1, p_ADDRESS_LINE_2,
1230: p_ADDRESS_LINE_3, p_TOWN_OR_CITY, p_COUNTRY,
1231: p_POSTAL_CODE, p_STATE, p_TELEPHONE_NUMBER_1,
1232: p_TELEPHONE_NUMBER_2, p_TELEPHONE_NUMBER_3
1233: from HZ_LOCATIONS HZA
1234: where HZA.LOCATION_ID = p_ship_to_location_id;
1235:
1236: /* it is not drop ship */
1237:

Line 1301: from HZ_LOCATIONS HZA

1297: p_ECE_TP_LOCATION_CODE, p_ADDRESS_LINE_1, p_ADDRESS_LINE_2,
1298: p_ADDRESS_LINE_3, p_TOWN_OR_CITY, p_COUNTRY,
1299: p_POSTAL_CODE, p_STATE, p_TELEPHONE_NUMBER_1,
1300: p_TELEPHONE_NUMBER_2, p_TELEPHONE_NUMBER_3
1301: from HZ_LOCATIONS HZA
1302: where HZA.LOCATION_ID = p_ship_to_location_id;
1303:
1304: /* it is not drop ship */
1305: else

Line 1879: FROM hz_locations hzl

1875: x_city,
1876: x_postalcode,
1877: x_country,
1878: x_stateprovn
1879: FROM hz_locations hzl
1880: where HzL.location_id = l_location_id;
1881: /*
1882: in case of drop ship no ece_tp_location_code?, telphone nubmers.
1883: */