How to find inventory organization full address

SELECT location_id, location_code, NAME, address_line_1, address_line_2,
       address_line_3, telephone_number_1, postal_code, loc_information14,
       loc_information15, loc_information16
  FROM hr_organization_units_v
  WHERE location_id is not null

How to Delete Concurrent Program and Executable

Remove Concurrent Program and Executable

Delete Concurrent Program 

Execute FND_PROGRAM.DELETE_PROGRAM('V_PROG_SHORT_NAME', 'V_APPL_SHORT_NAME');
 Commit;


Delete Concurrent Executable:


Execute FND_PROGRAM.DELETE_EXECUTABLE('V_PROG_SHORT_NAME', 'V_APPL_SHORT_NAME');

  Commit; 


Deleting the Template:
BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW('V_APPL_SHORT_NAME','V_PROG_SHORT_NAME');
END;


Deleting the Data Definition:
BEGIN
XDO_DS_DEFINITIONS_PKG.DELETE_ROW('V_APPL_SHORT_NAME','V_PROG_SHORT_NAME');
END;

Note: 
V_APPL_SHORT_NAME = application short name
V_PROG_SHORT_NAME = concurrent program short name