You are browsing the archive for Procurement.

Views in Oracle iProcurement Module

List of Views in Oracle iProcurement Module

ICX_ADMIN_LOV_BASE
ICX_ADMIN_RESP_FUNC_V
ICX_ADMIN_RESP_SEC_ATTR_V
ICX_ADMIN_USER_RESP_V
ICX_AK_ATTRIBUTES_VL
ICX_AP_CHECKS_V
ICX_AP_EXPENSE_LINES_V
ICX_AP_EXPENSE_REPORTS_V
ICX_AP_INVOICE_PAYMENTS_V
ICX_AP_INVOICES_V
ICX_AS_EVENT_FAC_STAFF_V
ICX_AS_EVENT_FACILITIES_V
ICX_AS_EVENT_FACSTAFF_COUNT_V
ICX_AS_EVENT_NAME_RQMNTS_V
ICX_CART_LINE_ACCOUNT_HEADER_V
ICX_CART_LINE_DISTRIBUTIONS_V
ICX_CAT_AGREEMENT_ATTRS_V
ICX_CAT_CATEGORIES_V
ICX_CAT_CONTENT_ZONES_VL
ICX_CAT_LATEST_BATCH_JOBS_V
ICX_CAT_PURCHASING_CAT_MAP_V
ICX_CAT_SHOP_STORES_VL
ICX_CAT_SHOPPING_CAT_MAP_V
ICX_CAT_STORE_CONTENTS_V
ICX_CATALOG_AVAIL_ITEMS_V
ICX_CATALOG_ORD_ITEMS_V
ICX_CATALOG_SUMMARY_V
ICX_CATEGORY_LOV
ICX_CATEGORY_SET_LOV
ICX_CATG_DETLS_INFO_V
ICX_CATG_DETLS_INFO_VL
ICX_CHV_ITEM_ORDERS_V
ICX_CHV_SCHEDULE_ITEMS_V
ICX_CHV_SCHEDULE_LINES_V
ICX_CONFIG_COMPONENTS_WEB_V
ICX_COST_GRP_INV_VALUE_V
ICX_CST_CUSTOMER_30DAY_V
ICX_CST_CUSTOMER_7DAY_V
ICX_CST_CUSTOMER_90DAY_V
ICX_CST_ITEM_30DAY_V
ICX_CST_ITEM_7DAY_V
ICX_CST_ITEM_90DAY_V
ICX_CST_MARGIN_BUILD_V
ICX_CST_MARGIN_DETAIL_V
ICX_CST_MARGIN_TEMP_V
ICX_CST_SALES_REP_30DAY_V
ICX_CST_SALES_REP_7DAY_V
ICX_CST_SALES_REP_90DAY_V
ICX_CST_TERRITORY_30DAY_V
ICX_CST_TERRITORY_7DAY_V
ICX_CST_TERRITORY_90DAY_V
ICX_EDM_BUYER_SUP_PROJ_V
ICX_EDM_BUYER_SUP_TASK_V
ICX_EDM_COST_GROUP_INV_V
ICX_EDM_CUSTOMER_TASK_V
ICX_EDM_INV_ONHAND_BAL_V
ICX_EDM_KEY_MEMBER_PROJ_V
ICX_EDM_KEY_MEMBER_TASK_V
ICX_EDM_MFG_PLAN_V
ICX_EDM_PLANNER_PROJ_V
ICX_EDM_PLANNER_TASK_V
ICX_EDM_PO_BLANKET_REL_V
ICX_EDM_PROJECT_TASK_V
ICX_EDM_PROJECT_V
ICX_EDM_PURCHASE_ORDER_V
ICX_EDM_PURCHASE_REQ_V
ICX_EDM_WIP_JOB_V
ICX_ENG_WEB_SCHEDULE_CS_V
ICX_ENG_WEB_SCHEDULE_PO_V
ICX_ENG_WEB_SCHEDULE_SO_V
ICX_FORM_FUNCTIONS_VL
ICX_HORIZONTAL_SCHEDULE_V
ICX_HR_LOCATIONS_V
ICX_HR_ORGS_LOV_V
ICX_INTERNAL_CONTACT_LOV
ICX_INTERNAL_SAV_DEFAULTS_V
ICX_ITEM_DETLS_INFO_V
ICX_ITEM_DETLS_INFO_VL
ICX_LOV_DUMMY_V
ICX_MRP_BUCKETED_FORECASTS_V
ICX_MRP_DUMMY_BUCKETED_PROC_V
ICX_MRP_FORECAST_DATES_V
ICX_MRP_FORECAST_UPDATES_V
ICX_MTL_DEMAND_ITEM_SUM_V
ICX_MTL_DEMAND_SUMMARY_V
ICX_MTL_ONHAND_ITEMS_DMMY_V
ICX_MTL_ONHAND_ITEMS_KFV
ICX_MTL_ONHAND_LOCATOR_KFV
ICX_MTL_ONHAND_LOT_KFV
ICX_MTL_ONHAND_REV_KFV
ICX_MTL_ONHAND_SERIAL_KFV
ICX_MTL_ONHAND_SUB_KFV
ICX_MTL_ONHAND_SUB_V
ICX_MTL_SALES_ORDERS_V
ICX_MTL_SUPPLY_DEMAND_V
ICX_MTL_SYSTEM_ITEMS_CONT_V
ICX_NONSHIP_DUMMY_LOV_V
ICX_NONSHIP_ITEMS_V
ICX_OE_DIRECT_ITEMS_V
ICX_ORG_ADDRESS_V
ICX_PAGES_VL
ICX_PANEL_SUMMARY_V
ICX_PANEL_TOTALS_V
ICX_PER_ORGANIZATION_UNITS_V
ICX_PER_PEOPLE_X_V
ICX_PLAN_SCHEDULE_HEADERS_V
ICX_PO_ACTION_HISTORY_PK_V
ICX_PO_APPROVER_VAL_V
ICX_PO_DISTRIBUTES_DIFF_V
ICX_PO_EMPLOYEE_DETAILS_V
ICX_PO_HDR_ARCHIVE_OPEN_V
ICX_PO_HEADER_DIFF_V
ICX_PO_HEADERS_ARCHIVE_V
ICX_PO_LATE_RECEIPTS_V
ICX_PO_LINE_DIST_DIFF_V
ICX_PO_LINE_LOC_DIFF_V
ICX_PO_LINES_ALL_CONTEXT_V
ICX_PO_LINES_DIFF_V
ICX_PO_LIST_USERS_V
ICX_PO_LOCATION_DETAIL_V
ICX_PO_LOCATIONS_DIFF_V
ICX_PO_MATCHED_INVOICES_V
ICX_PO_OPEN_REQS_BY_USERS_V
ICX_PO_OSP_V
ICX_PO_REQ_DIST_V
ICX_PO_REQ_HEADERS_V
ICX_PO_REQ_LINES_DIST_V
ICX_PO_REQ_LINES_V
ICX_PO_REQ_TEMPLATE_ITEMS_V
ICX_PO_REQS_BY_USERS_V
ICX_PO_REQUESTOR_VAL_V
ICX_PO_REQUISITION_HEADERS_V
ICX_PO_REQUISITION_LINES_INQ_V
ICX_PO_REQUISITION_OPEN_V
ICX_PO_REQUISITION_TEMPLATES_V
ICX_PO_REVISIONS_HEADER_V
ICX_PO_REVISIONS_LINE_V
ICX_PO_REVISIONS_TEMP_V
ICX_PO_RFQ_HEADERS_V
ICX_PO_RFQ_LINES_V
ICX_PO_SUP_ORDER_INVOICES_V
ICX_PO_SUPPL_CAT_ITEMS_V
ICX_PO_SUPPL_CATALOG_ITEMS_V
ICX_PO_SUPPL_SEARCH_ITEMS_V
ICX_PO_SUPPLIER_AGREEMENTS_V
ICX_PO_SUPPLIER_CATALOGS_V
ICX_PO_SUPPLIER_INFO_V
ICX_PO_SUPPLIER_ITEMS_V
ICX_PO_SUPPLIER_ORDERS_V
ICX_PO_USER_DETAILS_V
ICX_PO_VENDOR_CONTACTS_V
ICX_POR_CATEGORIES_VL
ICX_POR_CTLG_DUMMY_V
ICX_POR_DESCRIPTORS_VL
ICX_POR_EXT_ACTIVE_CONTRACTS
ICX_POR_EXT_CONTRACTS
ICX_POR_EXT_INACTIVE_CONTRACTS
ICX_POR_ITEM_SOURCES_FORM_V
ICX_POR_ITEM_SOURCES_VL
ICX_POR_REALM_COMP_FORM_V
ICX_POR_REALMS_FORM_V
ICX_POR_REALMS_VL
ICX_POR_REQ_ACTIVE_CONTRACTS
ICX_POR_REQ_ASLS
ICX_POR_REQ_CONTRACTS
ICX_POR_REQ_INACTIVE_CONTRACTS
ICX_POR_REQ_TEMPLATES
ICX_POR_SEARCH_ASLS_V
ICX_POR_SEARCH_CONTRACTS_V
ICX_POR_SEARCH_ITEM_MASTER_V
ICX_POS_QA_SHIPMENTS_V
ICX_PRICE_LIST_UOMS_V
ICX_PROCSERV_SETUP_FORM_V
ICX_QUESTIONS_VL
ICX_RA_CUSTOMER_TRX_LINES_V
ICX_RCV_ACCEPTED_ITEMS_V
ICX_RCV_EARLY_LATE_RECEIPTS_V
ICX_RCV_REJECTED_ITEMS_V
ICX_RCV_RETURNS_V
ICX_RCV_TRANSACTIONS_V
ICX_RECEIPT_HEADERS_V
ICX_RELATED_CATEGORIES_V
ICX_RELATED_CATEGORIES_VAL_V
ICX_RELATED_TEMPLATES_V
ICX_RELATED_TEMPLATES_VAL_V
ICX_REQ_CATEGORIES_V
ICX_REQ_DIST_HEADER_V
ICX_REQ_DIST_UPDATE_V
ICX_REQ_ONE_TIME_ITEM_V
ICX_REQ_SUPPLIERS_V
ICX_REQ_TEMPLATES_V
ICX_REQS_LOCATION_LOV
ICX_REQS_LOCATION_V
ICX_REQUESTER_LOV
ICX_SHIP_SCHEDULE_HEADERS_V
ICX_SHOPPING_CART_LINES_V
ICX_SHOPPING_CARTS_V
ICX_SO_LINES_VIEW_LINES_V
ICX_SO_LINES_VIEW_RETURNS_V
ICX_SO_PICKING_HDRS_LINES_V
ICX_SO_RMA_MTL_INT_DETAIL_V
ICX_SO_RMA_MTL_INT_V
ICX_START_V
ICX_SUPPLIER_ACCOUNT_V
ICX_SUPPLIER_CONTACT_LOV
ICX_SUPPLIER_ORG_LOV_V
ICX_SUPPLIER_SAV_DEFAULTS_V
ICX_SUPPLIER_SITE_LOV_V
ICX_TEMPLATE_LOV
ICX_TEMPLATE_TAGS_V
ICX_UNIT_OF_MEASUREMENT_V
ICX_WEBSTORE_CATEGORIES_V
ICX_WEBSTORE_ITEMS_V
ICX_WEBSTORE_SEARCH_ITEMS_V

Views in Oracle Supplier Scheduling Module

Views in Oracle Supplier Scheduling Module

CHV_AUTHORIZATION_HEADERS_V
CHV_AUTHORIZATIONS_DFV
CHV_AUTHORIZATIONS_V
CHV_BUCKET_PATTERNS_DFV
CHV_BUCKET_PATTERNS_VAL_V
CHV_CUM_ADJUSTMENTS_DFV
CHV_CUM_ITEMS_HISTORY_V
CHV_CUM_ITEMS_V
CHV_CUM_PERIOD_ITEMS_DFV
CHV_CUM_PERIODS_DFV
CHV_HORIZ_BKT_SCHEDULES_V
CHV_HORIZ_DATE_SCHEDULES_V
CHV_HORIZ_QTY_SCHEDULES_V
CHV_ITEM_ORDERS_DFV
CHV_ITEM_ORDERS_V
CHV_ORG_OPTIONS_DFV
CHV_ORG_OPTIONS_V
CHV_OWNERS_ALL_V
CHV_PLANNERS_ALL_V
CHV_PLANNERS_VAL_V
CHV_RECEIVING_TRANSACTIONS_V
CHV_SCHEDULE_HEADERS_ALL_V
CHV_SCHEDULE_HEADERS_DFV
CHV_SCHEDULE_HEADERS_V
CHV_SCHEDULE_HEADERS_VAL_V
CHV_SCHEDULE_ITEMS_DFV
CHV_SCHEDULE_ITEMS_V
CHV_SCHEDULERS_ALL_V
CHV_SCHEDULERS_VAL_V

Supplier Scheduling Descriptive Flex Fields

Oracle Supplier Scheduling Module DFF list:

DFF View DFF CODE NAME DFF name
CHV_AUTHORIZATIONS_DFV CHV_AUTHORIZATIONS Authorizations
CHV_BUCKET_PATTERNS_DFV CHV_BUCKET_PATTERNS Bucket Patterns
CHV_CUM_ADJUSTMENTS_DFV CHV_CUM_ADJUSTMENTS CUM Adjustments
CHV_CUM_PERIODS_DFV CHV_CUM_PERIODS CUM Periods
CHV_CUM_PERIOD_ITEMS_DFV CHV_CUM_PERIOD_ITEMS CUM Period Items
CHV_ITEM_ORDERS_DFV CHV_ITEM_ORDERS Item Orders
CHV_ORG_OPTIONS_DFV CHV_ORG_OPTIONS Organization Options
CHV_SCHEDULE_HEADERS_DFV CHV_SCHEDULE_HEADERS Schedule Headers
CHV_SCHEDULE_ITEMS_DFV CHV_SCHEDULE_ITEMS Schedule Items