CSP Views (93)

CSP - Spares Management — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`CSP_ARRIVAL_DATES_V`	This view shows the estimated arrival date for a required part.
`CSP_ASL_ITEMS_V`	This view lists all items on a stocklist
`CSP_AVAILABLE_PARTS_IN_LOOP_V`	Checks availability of part in a given loop and gives a list of all the subinventories
`CSP_CARRIER_DELIVERY_TIMES_V`	Shows Carrier Deliver times
`CSP_CURR_SUP_DEM_SUMS_V`	Supply and demand summary created by batchprogram
`CSP_CURR_SUP_DEM_SUMS_V2`	Supply and demand summary created by batchprogram
`CSP_DC_PARTS_V`
`CSP_ENGINEER_DAYS_V`
`CSP_EOO_CANCEL_RECOMM_V`	This view lists orders that can be canceled due to an excess on order notification.
`CSP_EXCESS_LISTS_V`	Excess Spare Parts
`CSP_EXCESS_RULES_VL`	Shows excess rules with translated description.
`CSP_FAILURE_RATES_V`	Lists failure rates for components of a product
`CSP_FORECAST_RULES_B_V`	Forecast rules
`CSP_FORECAST_RULES_VL`	Shows forecast rules with translated description.
`CSP_GET_LOT_NUMBERS_V`	Get the lot numbers associated with a part-in Item number
`CSP_GET_SERIAL_NUMBERS_V`	Get Serial Number associated with part-in Item number
`CSP_INV_LOC_ASSIGNMENTS_V`	Shows inventory locations assigned to resources
`CSP_ITEM_SUB_INVENTORIES_ALL_V`	Shows authorized stocklist for the subinventories.
`CSP_LOCATION_ADDRESS_V`	Shows all the existing Address
`CSP_LOOP_CALC_RULES_V`	Calculation rules
`CSP_LOOP_CALC_RULES_VL`	Shows calculation rules with translated description.
`CSP_MATERIAL_TRANSACTIONS_V1`	Shows material transactions for usage and sales order transactions
`CSP_MINMAX_NOTIFS_V`	Lists warehouse notifications
`CSP_MOVEORDERS_V`	The view gives the status of a moveorder.
`CSP_MOVEORDER_HEADERS_V`	Mover order headers including extra information for Spares Management
`CSP_MOVEORDER_LINES_V`	Mover order lines including extra information for Spares Management
`CSP_MO_LINES_V`	Move order lines including extra information of Spares Management
`CSP_MSTRSTCK_LISTS_ITMS_V`	Master Stocklist Details
`CSP_NAV_NODE_TYPES`	Meta data for Navigator tree
`CSP_NOTIFICATIONS_V`	Notification Details
`CSP_NOTIFICATION_DETAILS_V`	Lists notification recommendations
`CSP_NOT_PLOOP_NAV`	View for Notification Root to Parts Loop flow
`CSP_NOT_PLTYPES_NAV`	View for Parts Loop to Notification Types flow
`CSP_NOT_STAT_ITEMS_NAV`	View for Notification status to Items flow
`CSP_NOT_TYSTAT_NAV`	View for Notification Types to Status flow
`CSP_ORDERS_DUE_V`	Returns tasks that need to be assigned today.
`CSP_ORG_USAGE_DETAILS_V`
`CSP_PACKLIST_BOXES_V`	Boxes belonging to packlists
`CSP_PACKLIST_HEADERS_V`	Packlist header information
`CSP_PACKLIST_LINES_V`	Packlist line information
`CSP_PACKLIST_SERIAL_LOTS_V`	Serials or lots available for receipt
`CSP_PACK_LIST_NAV`	View for Packlist status to Packlist flow
`CSP_PARTS_LOOPS_B_V`	Parts Loop Details
`CSP_PARTS_LOOPS_NAV`	View for Parts Loop Root to Parts Loop flow
`CSP_PARTS_LOOPS_VL`	Shows parts loops with translated description.
`CSP_PART_CATEGORIES_V`	Shows the spare part categories.
`CSP_PICKLIST_HEADERS_V`	Picklist header information
`CSP_PICKLIST_LINES_V`	Picklist line information
`CSP_PICKLIST_LINES_V1`	Picklist line information
`CSP_PICKLIST_SERIAL_LOTS_V1`	Serial and lot number on a picklist
`CSP_PICK_TRANSACTIONS_V`	Material Transactions and Picklist information
`CSP_PLANNING_DETAILS_V`
`CSP_PLANNING_DRILLDOWN_V`
`CSP_PLANNING_HEADERS_V`
`CSP_PLANNING_ORG_HDR_V`
`CSP_PLANNING_PARAMETERS_V`
`CSP_PLANNING_SUBINV_HDR_V`
`CSP_PLANNING_TOPNODE_HDR_V`
`CSP_PLIST_BOXES_NAV`	View for Packlist to Boxes flow
`CSP_PLIST_BOXITEMS_NAV`	View for Box to Items flow
`CSP_PLIST_ITMSLNO_NAV`	View for packlist items to Serial/Lot flow
`CSP_PLIST_STATUS_NAV`	View for Packlist Root to Packlist status
`CSP_PLN_DRILLDOWN_ORG_V`
`CSP_PLN_DRILLDOWN_SUBINV_V`
`CSP_PLN_DRILLDOWN_SUBINV_WH_V`
`CSP_PLN_ORG_NAV`
`CSP_PLN_REGIONS_NAV`
`CSP_PLN_REGION_ORG_NAV`
`CSP_PLN_SUBINV_NAV`
`CSP_PRODUCT_POPULATIONS_FR_V`
`CSP_PRODUCT_POPULATIONS_V`
`CSP_PRODUCT_TASKS_V`	Product Task information
`CSP_RECV_PARTS_V`	Information about shipped packlists
`CSP_REGION_ITEMS_V`
`CSP_REG_USAGE_DETAILS_V`
`CSP_REP_HIERARCHIES_NAV`	View for Reporting Hierarchy Root to Reporting Hierarchy flow
`CSP_REP_HIERARCHIES_V`	Reporting Hierarchy Details
`CSP_REP_HIER_SECINV_NAV`	View for Reporting Hierarchy to Subinventory flow
`CSP_REQUIRED_PARTS_V`	View which gives you the complete status of spare part requirements
`CSP_REQUIREMENT_HEADERS_V`	Information about parts requirement headers
`CSP_REQ_LINE_DETAILS_V`	Information about requirement details
`CSP_RESOURCE_DEFAULT_INV_LOC_V`	Get the default Part In or Part Out Subinventories assigned to a resource in a loop
`CSP_RESOURCE_INV_LOC_V`	View all move orders and their statuses for a given Service Request and Task Id
`CSP_RS_RESOURCES_V`	View of resources with ship to addresses and subinventories assigned
`CSP_RS_SHIP_TO_ADDRESSES_V`	Resource ship to addresses view
`CSP_RS_SUBINVENTORIES_V`	Resource subinventory assignments view
`CSP_SEC_INVENTORIES_NAV`	View for Parts Loop to Subinventory flow
`CSP_SEC_INVENTORIES_V`	Subinventory Details
`CSP_SUBINV_USAGE_DETAILS_V`
`CSP_TASK_PARTS_V`	Task Part Information
`CSP_USAGE_HISTORIES_V`	Usage history generated by a batchprogram
`CSP_USAGE_HISTORIES_V1`	Used by spreadtable to display usage history
`CSP_USAGE_REG_ORG_SUBINV_V`