You are browsing the archive for Oracle Spares Management.

Views in Spares Management Module

Views in Oracle Spares Management Module

CSP_ARRIVAL_DATES_V
CSP_ASL_ITEMS_V
CSP_AVAILABLE_PARTS_IN_LOOP_V
CSP_AVAILABLE_PARTS_V
CSP_CARRIER_DELIVERY_TIMES_DFV
CSP_CARRIER_DELIVERY_TIMES_V
CSP_CURR_SUP_DEM_SUMS_V
CSP_CURR_SUP_DEM_SUMS_V2
CSP_DC_PARTS_V
CSP_DEDICATED_SITES_V
CSP_ENGINEER_DAYS_V
CSP_EOO_CANCEL_RECOMM_V
CSP_EXCESS_LISTS_DFV
CSP_EXCESS_LISTS_V
CSP_EXCESS_RULES_B_DFV
CSP_EXCESS_RULES_VL
CSP_FAILURE_RATES_V
CSP_FORECAST_RULES_B_DFV
CSP_FORECAST_RULES_B_V
CSP_FORECAST_RULES_VL
CSP_GET_LOT_NUMBERS_V
CSP_GET_SERIAL_NUMBERS_V
CSP_INV_LOC_ASSIGNMENTS_DFV
CSP_INV_LOC_ASSIGNMENTS_V
CSP_ITEM_SUB_INVENTORIES_ALL_V
CSP_LOCATION_ADDRESS_V
CSP_LOOP_CALC_RULES_B_DFV
CSP_LOOP_CALC_RULES_V
CSP_LOOP_CALC_RULES_VL
CSP_MATERIAL_TRANSACTIONS_V1
CSP_MINMAX_NOTIFS_V
CSP_MO_LINES_V
CSP_MOVEORDER_HEADERS_DFV
CSP_MOVEORDER_HEADERS_V
CSP_MOVEORDER_LINES_DFV
CSP_MOVEORDER_LINES_V
CSP_MOVEORDERS_V
CSP_MSTRSTCK_LISTS_ITMS_DFV
CSP_MSTRSTCK_LISTS_ITMS_V
CSP_NAV_NODE_TYPES
CSP_NEW_PRODUCT_PLANNING_V
CSP_NEXT_OPEN_V
CSP_NOT_PLOOP_NAV
CSP_NOT_PLTYPES_NAV
CSP_NOT_STAT_ITEMS_NAV
CSP_NOT_TYSTAT_NAV
CSP_NOTIFICATION_DETAILS_V
CSP_NOTIFICATION_RULES_VL
CSP_NOTIFICATIONS_DFV
CSP_NOTIFICATIONS_V
CSP_ONHAND_PARTS_V
CSP_OPEN_CLOSED_V
CSP_ORDERS_DUE_V
CSP_ORG_USAGE_DETAILS_V
CSP_PACK_LIST_NAV
CSP_PACKLIST_BOXES_DFV
CSP_PACKLIST_BOXES_V
CSP_PACKLIST_HEADERS_DFV
CSP_PACKLIST_HEADERS_V
CSP_PACKLIST_LINES_DFV
CSP_PACKLIST_LINES_V
CSP_PACKLIST_SERIAL_LOTS_V
CSP_PART_CATEGORIES_V
CSP_PART_PRIORITIES_V
CSP_PARTS_LOOPS_B_DFV
CSP_PARTS_LOOPS_B_V
CSP_PARTS_LOOPS_NAV
CSP_PARTS_LOOPS_VL
CSP_PARTS_REQUIREMENTS_V
CSP_PICK_CONFIRM_V
CSP_PICK_TRANSACTIONS_V
CSP_PICKLIST_HEADERS_DFV
CSP_PICKLIST_HEADERS_V
CSP_PICKLIST_LINES_DFV
CSP_PICKLIST_LINES_V
CSP_PICKLIST_LINES_V1
CSP_PICKLIST_SERIAL_LOTS_V1
CSP_PLAN_DETAILS_V
CSP_PLAN_SEARCH_V
CSP_PLANNING_DETAILS_V
CSP_PLANNING_DRILLDOWN_V
CSP_PLANNING_HEADERS_V
CSP_PLANNING_ORG_HDR_V
CSP_PLANNING_PARAMETERS_DFV
CSP_PLANNING_PARAMETERS_V
CSP_PLANNING_SUBINV_HDR_V
CSP_PLANNING_TOPNODE_HDR_V
CSP_PLIST_BOXES_NAV
CSP_PLIST_BOXITEMS_NAV
CSP_PLIST_ITMSLNO_NAV
CSP_PLIST_STATUS_NAV
CSP_PLN_DRILLDOWN_ORG_V
CSP_PLN_DRILLDOWN_SUBINV_V
CSP_PLN_DRILLDOWN_SUBINV_WH_V
CSP_PLN_ORG_NAV
CSP_PLN_REGION_ORG_NAV
CSP_PLN_REGIONS_NAV
CSP_PLN_SUBINV_NAV
CSP_PRODUCT_POPULATIONS_FR_V
CSP_PRODUCT_POPULATIONS_V
CSP_PRODUCT_TASKS_DFV
CSP_PRODUCT_TASKS_V
CSP_RECEIVE_HEADERS_V
CSP_RECEIVE_LINES_V
CSP_RECEIVING_HEADERS_V
CSP_RECEIVING_LINES_V
CSP_RECOMMENDATION_RULES_VL
CSP_RECV_PARTS_V
CSP_REG_USAGE_DETAILS_V
CSP_REGION_ITEMS_V
CSP_REP_HIER_SECINV_NAV
CSP_REP_HIERARCHIES_DFV
CSP_REP_HIERARCHIES_NAV
CSP_REP_HIERARCHIES_V
CSP_REQ_LINE_DETAILS_V
CSP_REQUIRED_PARTS_V
CSP_REQUIREMENT_HEADERS_DFV
CSP_REQUIREMENT_HEADERS_V
CSP_REQUIREMENT_LINES_DFV
CSP_RESCHEDULE_RULES_VL
CSP_RESOURCE_DEFAULT_INV_LOC_V
CSP_RESOURCE_INV_LOC_V
CSP_RS_CUST_RELATIONS_DFV
CSP_RS_RESOURCES_V
CSP_RS_SHIP_TO_ADDRESSES_ALL_V
CSP_RS_SHIP_TO_ADDRESSES_V
CSP_RS_SUBINVENTORIES_V
CSP_SEC_INVENTORIES_DFV
CSP_SEC_INVENTORIES_NAV
CSP_SEC_INVENTORIES_V
CSP_SHIPPING_DETAILS_V
CSP_SPARES_ORDERS_OM_V
CSP_SR_DR_LOV_V
CSP_STOCKING_SITE_DETAILS_V
CSP_SUBINV_USAGE_DETAILS_V
CSP_SUBINVENTORIES_V
CSP_SUP_DEM_PL_V
CSP_SUP_DEM_PN_V
CSP_SUP_DEM_RH_V
CSP_SUP_DEM_SUB_V
CSP_SUPERSESIONS_V
CSP_TASK_PARTS_DFV
CSP_TASK_PARTS_V
CSP_USAGE_HISTORIES_DFV
CSP_USAGE_HISTORIES_V
CSP_USAGE_HISTORIES_V1
CSP_USAGE_REG_ORG_SUBINV_V
CSP_USG_TRANSACTION_TYPES_V
CSP_WRP_RULES_VL

Spares Management Descriptive Flex Fields

Oracle Spares Management module DFF list

DFF View DFF CODE NAME DFF name
CSP_FORECAST_RULES_B_DFV CSP_FORECAST_RULES_B Forecast Rules
CSP_INV_LOC_ASSIGNMENTS_DFV CSP_INV_LOC_ASSIGNMENTS Inventory Assignments
CSP_LOOP_CALC_RULES_B_DFV CSP_LOOP_CALC_RULES_B Calculation Rules
CSP_MOVEORDER_HEADERS_DFV CSP_MOVEORDER_HEADERS Move Order Headers
CSP_MOVEORDER_LINES_DFV CSP_MOVEORDER_LINES Move Order Lines
CSP_MSTRSTCK_LISTS_ITMS_DFV CSP_MSTRSTCK_LIST_ITMS Master Stocklist
CSP_NOTIFICATIONS_DFV CSP_NOTIFICATIONS Notifications
CSP_PACKLIST_BOXES_DFV CSP_PACKLIST_BOXES Packlist Boxes
CSP_PACKLIST_HEADERS_DFV CSP_PACKLIST_HEADERS Packlist Headers
CSP_PACKLIST_LINES_DFV CSP_PACKLIST_LINES Packlist Lines
CSP_PARTS_LOOPS_B_DFV CSP_PARTS_LOOPS_B Parts Loops
CSP_PICKLIST_HEADERS_DFV CSP_PICKLIST_HEADERS Picklist Headers
CSP_PICKLIST_LINES_DFV CSP_PICKLIST_LINES Picklist Lines
CSP_REP_HIERARCHIES_DFV CSP_REP_HIERARCHIES Reporting Hierarchies
CSP_SEC_INVENTORIES_DFV CSP_SEC_INVENTORIES Secondary Inventories
CSP_USAGE_HISTORIES_DFV CSP_USAGE_HISTORIES Usage Histories
CSP_CARRIER_DELIVERY_TIMES_DFV CSP_CARRIER_DELIVERY_TIMES Carrier Delivery Times
CSP_REQUIREMENT_LINES_DFV CSP_REQUIREMENT_LINES Spares Requirement Lines
CSP_EXCESS_LISTS_DFV CSP_EXCESS_LISTS Excess Lists
CSP_EXCESS_RULES_B_DFV CSP_EXCESS_RULES_B Excess Rules
CSP_RS_CUST_RELATIONS_DFV CSP_RS_CUST_RELATIONS Resource Customer Relationship
CSP_TASK_PARTS_DFV CSP_TASK_PARTS Task Parts
CSP_PLANNING_PARAMETERS_DFV CSP_PLANNING_PARAMETERS Planning Parameters
CSP_PRODUCT_TASKS_DFV CSP_PRODUCT_TASKS Product Tasks
CSP_REQUIREMENT_HEADERS_DFV CSP_REQUIREMENT_HEADERS Spares Requirement Headers

Spares Management Concurrent Programs

Oracle Spares Management Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
CSPPLSDS Create Part Availability Data
CSPTRPKL Picklist
CSPTRPAL Packlist
CSPPLUSH Create Usage History
CSPPLNOT Create Notifications
CSPTRCPI2 Create Picklists
CSPPLEXC Create Excess Lists
CSPPLTPH Create Task Parts History
CSPTREXC Create or Update Product-Task-Parts History
CSPPLPLN Generate Recommendations
CSPTREPL Print Excess List
CSPPLFRT Calculate Failure Rates
CSPPLURL Create Usage Rollup
CSPPLUSG Create Usage for Recommendations
CSPPLSUP Process Supersede Items
CSPPLPNT Create Warehouse Notifications
CSPPLEXC1 Create Excess/Defective Lists
CSPPLMMX Create Min-Max Report
CSPPLWRP Create Warehouse Replenishment Data
CSPPLREP Generate repair purchase order execution details
CSPTREPL_XML Print Excess List (XML)
CSPTRPKL_XML Picklist (XML)