APPS.CSD_BULK_RECEIVE_UTIL dependencies on CSI_ITEM_INSTANCES

Line 34: from csi_item_instances

30: Cursor c_get_ib_info ( p_inventory_item_id in Number,p_serial_number in Varchar2) is
31: Select
32: owner_party_id,
33: instance_id
34: from csi_item_instances
35: where serial_number = p_serial_number
36: and inventory_item_id = p_inventory_item_id;
37:
38: -- Cursor to verify the Serial number against the Item

Line 447: from csi_item_instances

443: Cursor c_get_ib_info ( p_inventory_item_id in Number,p_serial_number in Varchar2) is
444: Select
445: owner_party_id,
446: instance_id
447: from csi_item_instances
448: where serial_number = p_serial_number
449: and inventory_item_id = p_inventory_item_id;
450:
451: -- Cursor to get Item Revision

Line 482: from csi_item_instances

478: where incident_id = p_incident_id;
479:
480: Cursor c_get_install_site_use_id(p_instance_id in number) is
481: Select location_id
482: from csi_item_instances
483: where instance_id = p_instance_id;
484:
485: l_ent_contracts OKS_ENTITLEMENTS_PUB.GET_CONTOP_TBL;
486: l_calc_resptime_flag Varchar2(1) := 'Y';

Line 1006: Select object_version_number from csi_item_instances

1002: and relationship_type_code = 'OWNER';
1003:
1004: -- Cursor to derive the Instance details
1005: Cursor c_instance_details(p_instance_id number) IS
1006: Select object_version_number from csi_item_instances
1007: where instance_id = p_instance_id;
1008:
1009: -- Cursor to derive the Bulk Receive rec
1010: Cursor c_bulk_receive_items(p_bulk_receive_id Number) IS

Line 1024: from csi_item_instances

1020:
1021: -- Cursor to get IB details
1022: Cursor c_get_ib_info ( p_inventory_item_id in Number,p_serial_number in Varchar2) is
1023: Select instance_id
1024: from csi_item_instances
1025: where serial_number = p_serial_number
1026: and inventory_item_id = p_inventory_item_id;
1027:
1028: