APPS.CSI_JAVA_INTERFACE_PKG dependencies on CSI_ITEM_INSTANCES

Line 1115: FROM csi_item_instances_h

1111: x_index := 1;
1112: BEGIN
1113: SELECT 'x'
1114: INTO l_dummy
1115: FROM csi_item_instances_h
1116: WHERE transaction_id = p_transaction_id
1117: AND ROWNUM = 1;
1118:
1119: csi_item_instance_pvt.get_instance_hist

Line 1910: FROM csi_item_instances

1906: found_flag varchar2(1) :='N';
1907:
1908: CURSOR c_item_instances(l_instance_id NUMBER) IS
1909: SELECT serial_number
1910: FROM csi_item_instances
1911: WHERE instance_id =l_instance_id ;
1912:
1913: CURSOR c_nsrl_item_instances(n_instance_id NUMBER) IS
1914: SELECT CIIH.INSTANCE_ID FROM

Line 1915: CSI_ITEM_INSTANCES_H ciih,

1911: WHERE instance_id =l_instance_id ;
1912:
1913: CURSOR c_nsrl_item_instances(n_instance_id NUMBER) IS
1914: SELECT CIIH.INSTANCE_ID FROM
1915: CSI_ITEM_INSTANCES_H ciih,
1916: csi_item_instances cii
1917: WHERE
1918: cii.instance_id =ciih.instance_id
1919: AND cii.SERIAL_NUMBER IS NULL

Line 1916: csi_item_instances cii

1912:
1913: CURSOR c_nsrl_item_instances(n_instance_id NUMBER) IS
1914: SELECT CIIH.INSTANCE_ID FROM
1915: CSI_ITEM_INSTANCES_H ciih,
1916: csi_item_instances cii
1917: WHERE
1918: cii.instance_id =ciih.instance_id
1919: AND cii.SERIAL_NUMBER IS NULL
1920: and ciiH.INSTANCE_ID NOT IN n_instance_id

Line 1922: ( SELECT MAX(TRANSACTION_ID) FROM CSI_ITEM_INSTANCES_H WHERE INSTANCE_ID

1918: cii.instance_id =ciih.instance_id
1919: AND cii.SERIAL_NUMBER IS NULL
1920: and ciiH.INSTANCE_ID NOT IN n_instance_id
1921: AND TRANSACTION_ID IN
1922: ( SELECT MAX(TRANSACTION_ID) FROM CSI_ITEM_INSTANCES_H WHERE INSTANCE_ID
1923: = n_instance_id);
1924:
1925: BEGIN
1926: