[Home] [Help] [Dependency Information]
Object Name: | MRP_ITEM_TASK_SR_LEVELS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MRP.MRP_ITEM_TASK_SR_LEVELS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
ASSIGNMENT_TYPE | NUMBER | Type of item assignment: Site, Org, Item, etc. | ||
ASSIGNMENT_SET_ID | NUMBER | Assignment set identifier | ||
SOURCING_RULE_TYPE | NUMBER | Sourcing rule / BOD | ||
SOURCE_ORGANIZATION_ID | NUMBER | Source organization identifier | ||
VENDOR_ID | NUMBER | Vendor identifier | ||
VENDOR_SITE_ID | NUMBER | Vendor site identifier | ||
ALLOCATION_PERCENT | NUMBER | Sourcing allocation percentage | ||
RANK | NUMBER | Sourcing rank | ||
EFFECTIVE_DATE | DATE | Sourcing effective date | ||
DISABLE_DATE | DATE | Sourcing disable date | ||
CATEGORY_ID | NUMBER | Item category identifier | ||
SOURCING_LEVEL | NUMBER | Sourcing level (1 through 11) | ||
ASSIGNMENT_ID | NUMBER | Sourcing assignment identifier | ||
SOURCING_RULE_ID | NUMBER | Sourcing rule identifier | ||
SOURCING_RULE_NAME | VARCHAR2 | (50) | Sourcing rule | |
SOURCE_TYPE | NUMBER | Source type: Transfer / Make / Buy | ||
SOURCE_ORG_CODE | VARCHAR2 | (3) | Source organization | |
SR_DESCRIPTION | VARCHAR2 | (80) | Sourcing rule description | |
COMPILE_DESIGNATOR | VARCHAR2 | (10) | MPS, MRP or DRP plan identifier | |
OWNING_ORG_ID | NUMBER | Owning organization identifier | ||
MRP_PLANNING_CODE | NUMBER | Item planning code | ||
INVENTORY_ITEM_FLAG | VARCHAR2 | (1) | Inventory item? | |
ENG_ITEM_FLAG | VARCHAR2 | (1) | Engineering item? | |
BOM_ITEM_TYPE | NUMBER | BOM item type | ||
PLANNING_MAKE_BUY_CODE | NUMBER | Make / buy item? | ||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary UOM code | |
COMP_MRP_PLANNING_CODE | NUMBER | Item planning code |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, ASSIGNMENT_TYPE
, ASSIGNMENT_SET_ID
, SOURCING_RULE_TYPE
, SOURCE_ORGANIZATION_ID
, VENDOR_ID
, VENDOR_SITE_ID
, ALLOCATION_PERCENT
, RANK
, EFFECTIVE_DATE
, DISABLE_DATE
, CATEGORY_ID
, SOURCING_LEVEL
, ASSIGNMENT_ID
, SOURCING_RULE_ID
, SOURCING_RULE_NAME
, SOURCE_TYPE
, SOURCE_ORG_CODE
, SR_DESCRIPTION
, COMPILE_DESIGNATOR
, OWNING_ORG_ID
, MRP_PLANNING_CODE
, INVENTORY_ITEM_FLAG
, ENG_ITEM_FLAG
, BOM_ITEM_TYPE
, PLANNING_MAKE_BUY_CODE
, PRIMARY_UOM_CODE
, COMP_MRP_PLANNING_CODE
FROM APPS.MRP_ITEM_TASK_SR_LEVELS_V;
APPS.MRP_ITEM_TASK_SR_LEVELS_V is not referenced by any database object
|
|
|