eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_ASSET_LOG_PVT dependencies on HZ_LOCATIONS

Line 791: hz_locations hz,

787: ||hz.postal_code
788: ||','
789: ||hz.country
790: FROM
791: hz_locations hz,
792: hz_party_sites hps
793: WHERE
794: hz.location_id = hps.location_id
795: AND hps.party_site_id = ciih.old_location_id),

Line 796: 'HZ_LOCATIONS', (SELECT hz.address1

792: hz_party_sites hps
793: WHERE
794: hz.location_id = hps.location_id
795: AND hps.party_site_id = ciih.old_location_id),
796: 'HZ_LOCATIONS', (SELECT hz.address1
797: ||','
798: ||hz.address2
799: ||','
800: ||hz.address3

Line 812: FROM hz_locations hz

808:
809: ||hz.postal_code
810: ||','
811: ||hz.country
812: FROM hz_locations hz
813: WHERE
814: hz.location_id = ciih.old_location_id),
815: 'VENDOR_SITE', (SELECT
816: pvs.address_line1

Line 872: FROM hz_locations hz

868: ||','
869: ||hz.postal_code
870: ||','
871: ||hz.country
872: FROM hz_locations hz
873: WHERE hz.location_id = ciih.old_location_id),
874: 'PROJECT', (SELECT hz.address1
875: ||','
876: ||hz.address2

Line 889: FROM hz_locations hz

885: ||','
886: ||hz.postal_code
887: ||','
888: ||hz.country
889: FROM hz_locations hz
890: WHERE hz.location_id = ciih.old_location_id),
891: 'IN_TRANSIT', (SELECT hz.address1
892: ||','
893: ||hz.address2

Line 906: FROM hz_locations hz

902: ||','
903: ||hz.postal_code
904: ||','
905: ||hz.country
906: FROM hz_locations hz
907: WHERE hz.location_id = ciih.old_location_id),
908: 'PO', (SELECT hz.address1
909: ||','
910: ||hz.address2

Line 923: FROM hz_locations hz

919: ||','
920: ||hz.postal_code
921: ||','
922: ||hz.country
923: FROM hz_locations hz
924: WHERE
925: hz.location_id = ciih.old_location_id),
926: NULL) INTO l_old_loc_name
927: FROM csi_item_instances_H ciih

Line 949: hz_locations hz,

945: ||hz.postal_code
946: ||','
947: ||hz.country
948: FROM
949: hz_locations hz,
950: hz_party_sites hps
951: WHERE
952: hz.location_id = hps.location_id
953: AND hps.party_site_id = ciih.new_location_id),

Line 954: 'HZ_LOCATIONS', (SELECT hz.address1

950: hz_party_sites hps
951: WHERE
952: hz.location_id = hps.location_id
953: AND hps.party_site_id = ciih.new_location_id),
954: 'HZ_LOCATIONS', (SELECT hz.address1
955: ||','
956: ||hz.address2
957: ||','
958: ||hz.address3

Line 970: FROM hz_locations hz

966:
967: ||hz.postal_code
968: ||','
969: ||hz.country
970: FROM hz_locations hz
971: WHERE
972: hz.location_id = ciih.new_location_id),
973: 'VENDOR_SITE', (SELECT
974: pvs.address_line1

Line 1030: FROM hz_locations hz

1026: ||','
1027: ||hz.postal_code
1028: ||','
1029: ||hz.country
1030: FROM hz_locations hz
1031: WHERE hz.location_id = ciih.new_location_id),
1032: 'PROJECT', (SELECT hz.address1
1033: ||','
1034: ||hz.address2

Line 1047: FROM hz_locations hz

1043: ||','
1044: ||hz.postal_code
1045: ||','
1046: ||hz.country
1047: FROM hz_locations hz
1048: WHERE hz.location_id = ciih.new_location_id),
1049: 'IN_TRANSIT', (SELECT hz.address1
1050: ||','
1051: ||hz.address2

Line 1064: FROM hz_locations hz

1060: ||','
1061: ||hz.postal_code
1062: ||','
1063: ||hz.country
1064: FROM hz_locations hz
1065: WHERE hz.location_id = ciih.new_location_id),
1066: 'PO', (SELECT hz.address1
1067: ||','
1068: ||hz.address2

Line 1081: FROM hz_locations hz

1077: ||','
1078: ||hz.postal_code
1079: ||','
1080: ||hz.country
1081: FROM hz_locations hz
1082: WHERE
1083: hz.location_id = ciih.new_location_id),
1084: NULL) INTO l_new_loc_name
1085: FROM csi_item_instances_H ciih