APPS.CSI_JAVA_INTERFACE_PKG dependencies on CSI_ITEM_INSTANCES_H

Line 1116: FROM csi_item_instances_h

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

Line 1916: CSI_ITEM_INSTANCES_H ciih,

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

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

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