APPS.CSM_SERVICE_REQUESTS_PKG dependencies on CSI_ITEM_INSTANCES

Line 62: FROM CSI_ITEM_INSTANCES

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 */
66: CURSOR C_FREE_FORM_SER_INFO (c_serial_number IN VARCHAR2)

Line 73: FROM CSI_ITEM_INSTANCES

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 */
77: CURSOR c_customer_account ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE)

Line 138: FROM csi_item_instances

134: --115.10
135: CURSOR l_install_site_csr (p_customer_product_id IN number)
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

Line 143: l_install_location_id csi_item_instances.install_location_id%TYPE;

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;
145: l_user_id NUMBER;
146: l_msg_count NUMBER;
147: l_msg_data VARCHAR2(240);

Line 520: FROM csi_item_instances

516: --115.10
517: CURSOR l_install_site_csr (p_customer_product_id IN number)
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;

Line 524: l_install_location_id csi_item_instances.install_location_id%TYPE;

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:
527: r_last_update_date c_last_update_date%ROWTYPE;
528: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;