APPS.CS_CHARGE_DETAILS_PVT dependencies on CSI_ITEM_INSTANCES

Line 1207: FROM csi_item_instances

1203:
1204: Cursor c_instance(p_instance_id IN NUMBER,
1205: p_inv_id IN NUMBER) IS
1206: SELECT instance_id
1207: FROM csi_item_instances
1208: WHERE instance_id = p_instance_id
1209: AND inventory_item_id = p_inv_id;
1210: --AND INV_MASTER_ORGANIZATION_ID = cs_std.get_item_valdn_orgzn_id;
1211:

Line 1255: FROM CSI_ITEM_INSTANCES cp,

1251: IS
1252:
1253: CURSOR c_instance IS
1254: SELECT 'Y'
1255: FROM CSI_ITEM_INSTANCES cp,
1256: MTL_SYSTEM_ITEMS_KFV ITEMS
1257: WHERE cp.instance_id = p_instance_id AND
1258: CP.OWNER_PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND
1259: cp.owner_party_id = p_party_id AND

Line 1315: FROM csi_item_instances

1311: IS
1312:
1313: Cursor c_instance_serial_number IS
1314: SELECT 'Y'
1315: FROM csi_item_instances
1316: WHERE instance_id = p_instance_id
1317: AND serial_number = p_serial_number;
1318:
1319: lv_exists_flag VARCHAR2(1) := 'N';

Line 3644: FROM csi_item_instances

3640:
3641: -- Added for bug#5125934
3642: Cursor c_serial_number(p_instance_id NUMBER) IS
3643: SELECT serial_number
3644: FROM csi_item_instances
3645: WHERE instance_id = p_instance_id;
3646:
3647: BEGIN
3648: