APPS.CSM_SERVICE_REQUESTS_PKG dependencies on HZ_PARTY_SITES

Line 60: DECODE(INSTALL_LOCATION_TYPE_CODE,'HZ_PARTY_SITES','HZ_PARTY_SITE','HZ_LOCATIONS','HZ_LOCATION', NULL) AS INSTALL_LOCATION_TYPE_CODE,

56: IS
57: SELECT INSTANCE_ID, INVENTORY_ITEM_ID, LAST_VLD_ORGANIZATION_ID,
58: OWNER_PARTY_ID, INSTALL_LOCATION_ID, OWNER_PARTY_ACCOUNT_ID,
59: SERIAL_NUMBER, INVENTORY_REVISION,
60: DECODE(INSTALL_LOCATION_TYPE_CODE,'HZ_PARTY_SITES','HZ_PARTY_SITE','HZ_LOCATIONS','HZ_LOCATION', NULL) AS INSTALL_LOCATION_TYPE_CODE,
61: LOCATION_ID, DECODE(LOCATION_TYPE_CODE,'HZ_PARTY_SITES','HZ_PARTY_SITE','HZ_LOCATIONS','HZ_LOCATION', NULL) AS LOCATION_TYPE_CODE
62: FROM CSI_ITEM_INSTANCES
63: WHERE INSTANCE_NUMBER = c_instance_number;
64:

Line 61: LOCATION_ID, DECODE(LOCATION_TYPE_CODE,'HZ_PARTY_SITES','HZ_PARTY_SITE','HZ_LOCATIONS','HZ_LOCATION', NULL) AS LOCATION_TYPE_CODE

57: SELECT INSTANCE_ID, INVENTORY_ITEM_ID, LAST_VLD_ORGANIZATION_ID,
58: OWNER_PARTY_ID, INSTALL_LOCATION_ID, OWNER_PARTY_ACCOUNT_ID,
59: SERIAL_NUMBER, INVENTORY_REVISION,
60: DECODE(INSTALL_LOCATION_TYPE_CODE,'HZ_PARTY_SITES','HZ_PARTY_SITE','HZ_LOCATIONS','HZ_LOCATION', NULL) AS INSTALL_LOCATION_TYPE_CODE,
61: LOCATION_ID, DECODE(LOCATION_TYPE_CODE,'HZ_PARTY_SITES','HZ_PARTY_SITE','HZ_LOCATIONS','HZ_LOCATION', NULL) AS LOCATION_TYPE_CODE
62: FROM CSI_ITEM_INSTANCES
63: WHERE INSTANCE_NUMBER = c_instance_number;
64:
65: /* Cursor for Free Form Serial */

Line 71: DECODE(INSTALL_LOCATION_TYPE_CODE,'HZ_PARTY_SITES','HZ_PARTY_SITE','HZ_LOCATIONS','HZ_LOCATION', NULL) AS INSTALL_LOCATION_TYPE_CODE,

67: IS
68: SELECT INSTANCE_ID, INVENTORY_ITEM_ID, LAST_VLD_ORGANIZATION_ID,
69: OWNER_PARTY_ID, INSTALL_LOCATION_ID, OWNER_PARTY_ACCOUNT_ID,
70: SERIAL_NUMBER, INVENTORY_REVISION,
71: DECODE(INSTALL_LOCATION_TYPE_CODE,'HZ_PARTY_SITES','HZ_PARTY_SITE','HZ_LOCATIONS','HZ_LOCATION', NULL) AS INSTALL_LOCATION_TYPE_CODE,
72: LOCATION_ID, DECODE(LOCATION_TYPE_CODE,'HZ_PARTY_SITES','HZ_PARTY_SITE','HZ_LOCATIONS','HZ_LOCATION', NULL) AS LOCATION_TYPE_CODE
73: FROM CSI_ITEM_INSTANCES
74: WHERE SERIAL_NUMBER = c_serial_number;
75:

Line 72: LOCATION_ID, DECODE(LOCATION_TYPE_CODE,'HZ_PARTY_SITES','HZ_PARTY_SITE','HZ_LOCATIONS','HZ_LOCATION', NULL) AS LOCATION_TYPE_CODE

68: SELECT INSTANCE_ID, INVENTORY_ITEM_ID, LAST_VLD_ORGANIZATION_ID,
69: OWNER_PARTY_ID, INSTALL_LOCATION_ID, OWNER_PARTY_ACCOUNT_ID,
70: SERIAL_NUMBER, INVENTORY_REVISION,
71: DECODE(INSTALL_LOCATION_TYPE_CODE,'HZ_PARTY_SITES','HZ_PARTY_SITE','HZ_LOCATIONS','HZ_LOCATION', NULL) AS INSTALL_LOCATION_TYPE_CODE,
72: LOCATION_ID, DECODE(LOCATION_TYPE_CODE,'HZ_PARTY_SITES','HZ_PARTY_SITE','HZ_LOCATIONS','HZ_LOCATION', NULL) AS LOCATION_TYPE_CODE
73: FROM CSI_ITEM_INSTANCES
74: WHERE SERIAL_NUMBER = c_serial_number;
75:
76: /* Cursor to get the customer account id */

Line 108: FROM hz_party_sites site, hz_party_site_uses use

104: Cursor to get the Bill to Address */
105: CURSOR c_bill_to_site_id( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE)
106: IS
107: SELECT use.party_site_use_id
108: FROM hz_party_sites site, hz_party_site_uses use
109: WHERE site.party_site_id = use.party_site_id
110: AND site.status= 'A'
111: AND use.site_use_type= 'BILL_TO'
112: AND use.primary_per_type = 'Y'

Line 123: FROM hz_party_sites site, hz_party_site_uses use

119: Cursor to get the Ship to Address */
120: CURSOR c_ship_to_site_id ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE)
121: IS
122: SELECT use.party_site_use_id
123: FROM hz_party_sites site, hz_party_site_uses use
124:
125: WHERE site.party_site_id = use.party_site_id
126: AND site.status= 'A'
127: AND use.site_use_type= 'SHIP_TO'

Line 140: AND install_location_type_code IN ('HZ_PARTY_SITES','HZ_LOCATIONS');

136: IS
137: SELECT install_location_id
138: FROM csi_item_instances
139: WHERE instance_id = p_customer_product_id
140: AND install_location_type_code IN ('HZ_PARTY_SITES','HZ_LOCATIONS');
141:
142: --Variable Declarations
143: l_install_location_id csi_item_instances.install_location_id%TYPE;
144: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;

Line 522: AND install_location_type_code = 'HZ_PARTY_SITES';

518: IS
519: SELECT install_location_id
520: FROM csi_item_instances
521: WHERE instance_id = p_customer_product_id
522: AND install_location_type_code = 'HZ_PARTY_SITES';
523:
524: l_install_location_id csi_item_instances.install_location_id%TYPE;
525: --
526: