APPS.CSD_BULK_RECEIVE_UTIL dependencies on CSI_ITEM_INSTANCES

Line 511: from csi_item_instances

507: Cursor c_get_ib_info ( p_inventory_item_id in Number,p_serial_number in Varchar2) is
508: Select
509: owner_party_id,
510: instance_id
511: from csi_item_instances
512: where serial_number = p_serial_number
513: and inventory_item_id = p_inventory_item_id;
514:
515: -- Cursor to verify the Serial number against the Item

Line 970: from csi_item_instances

966: Cursor c_get_ib_info ( p_inventory_item_id in Number,p_serial_number in Varchar2) is
967: Select
968: owner_party_id,
969: instance_id
970: from csi_item_instances
971: where serial_number = p_serial_number
972: and inventory_item_id = p_inventory_item_id;
973:
974: -- Cursor to get Item Revision

Line 1005: from csi_item_instances

1001: where incident_id = p_incident_id;
1002:
1003: Cursor c_get_install_site_use_id(p_instance_id in number) is
1004: Select location_id
1005: from csi_item_instances
1006: where instance_id = p_instance_id;
1007:
1008: l_ent_contracts OKS_ENTITLEMENTS_PUB.GET_CONTOP_TBL;
1009: l_calc_resptime_flag Varchar2(1) := 'Y';

Line 1562: Select object_version_number from csi_item_instances

1558: and relationship_type_code = 'OWNER';
1559:
1560: -- Cursor to derive the Instance details
1561: Cursor c_instance_details(p_instance_id number) IS
1562: Select object_version_number from csi_item_instances
1563: where instance_id = p_instance_id;
1564:
1565: -- Cursor to derive the Bulk Receive rec
1566: Cursor c_bulk_receive_items(p_bulk_receive_id Number) IS

Line 1580: from csi_item_instances

1576:
1577: -- Cursor to get IB details
1578: Cursor c_get_ib_info ( p_inventory_item_id in Number,p_serial_number in Varchar2) is
1579: Select instance_id
1580: from csi_item_instances
1581: where serial_number = p_serial_number
1582: and inventory_item_id = p_inventory_item_id;
1583:
1584: --bug#8508030