DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.WMS_COST_GROUPS_INPUT_V

Object Details
Object Name: WMS_COST_GROUPS_INPUT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWMS.WMS_COST_GROUPS_INPUT_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER

HEADER_ID NUMBER

LINE_NUMBER NUMBER

ORGANIZATION_ID NUMBER

INVENTORY_ITEM_ID NUMBER

REVISION VARCHAR2 (3)
FROM_SUBINVENTORY_ID NUMBER

FROM_SUBINVENTORY_CODE VARCHAR2 (10)
FROM_LOCATOR_ID NUMBER

TO_SUBINVENTORY_CODE VARCHAR2 (10)
TO_SUBINVENTORY_ID NUMBER

TO_LOCATOR_ID NUMBER

TO_ACCOUNT_ID NUMBER

LOT_NUMBER VARCHAR2 (80)
SERIAL_NUMBER_START VARCHAR2 (30)
SERIAL_NUMBER_END VARCHAR2 (30)
UOM_CODE VARCHAR2 (3)
QUANTITY NUMBER

QUANTITY_DELIVERED NUMBER

QUANTITY_DETAILED NUMBER

DATE_REQUIRED DATE

REASON_ID NUMBER

REFERENCE VARCHAR2 (240)
REFERENCE_TYPE_CODE NUMBER

REFERENCE_ID NUMBER

PROJECT_ID NUMBER

TASK_ID NUMBER

TRANSACTION_HEADER_ID NUMBER

LINE_STATUS NUMBER

STATUS_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

LAST_UPDATE_DATE DATE

CREATED_BY NUMBER

CREATION_DATE DATE

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
TXN_SOURCE_ID NUMBER

TXN_SOURCE_LINE_ID NUMBER

TXN_SOURCE_LINE_DETAIL_ID NUMBER

TRANSACTION_TYPE_ID NUMBER

TRANSACTION_SOURCE_TYPE_ID NUMBER

PRIMARY_QUANTITY NUMBER

TO_ORGANIZATION_ID NUMBER

PUT_AWAY_STRATEGY_ID NUMBER

PICK_STRATEGY_ID NUMBER

UNIT_NUMBER VARCHAR2 (60)
SHIP_TO_LOCATION_ID NUMBER

FROM_COST_GROUP_ID NUMBER

TO_COST_GROUP_ID NUMBER

LPN_ID NUMBER

TO_LPN_ID NUMBER

SOURCE_CODE VARCHAR2 (30)
SOURCE_LINE_ID NUMBER

TRANSACTION_MODE NUMBER

LOCK_FLAG VARCHAR2 (1)
TRANSACTION_COST NUMBER

TRANSACTION_ACTION_ID NUMBER

TRANSACTION_SOURCE_ID NUMBER

TRANSACTION_SOURCE_NAME VARCHAR2 (80)
TRANSACTION_DATE DATE

ACCT_PERIOD_ID NUMBER

DISTRIBUTION_ACCOUNT_ID NUMBER

REQUISITION_LINE_ID NUMBER

REQUISITION_DISTRIBUTION_ID NUMBER

LOT_EXPIRATION_DATE DATE

SERIAL_NUMBER VARCHAR2 (30)
RECEIVING_DOCUMENT VARCHAR2 (10)
DEMAND_ID NUMBER

RCV_TRANSACTION_ID NUMBER

MOVE_TRANSACTION_ID NUMBER

COMPLETION_TRANSACTION_ID NUMBER

WIP_ENTITY_TYPE NUMBER

SCHEDULE_ID NUMBER

REPETITIVE_LINE_ID NUMBER

EMPLOYEE_CODE VARCHAR2 (10)
PRIMARY_SWITCH NUMBER

SCHEDULE_UPDATE_CODE NUMBER

SETUP_TEARDOWN_CODE NUMBER

ITEM_ORDERING NUMBER

NEGATIVE_REQ_FLAG NUMBER

OPERATION_SEQ_NUM NUMBER

PICKING_LINE_ID NUMBER

TRX_SOURCE_DELIVERY_ID NUMBER

PHYSICAL_ADJUSTMENT_ID NUMBER

CYCLE_COUNT_ID NUMBER

RMA_LINE_ID NUMBER

CUSTOMER_SHIP_ID NUMBER

CURRENCY_CODE VARCHAR2 (10)
CURRENCY_CONVERSION_RATE NUMBER

CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

USSGL_TRANSACTION_CODE VARCHAR2 (30)
VENDOR_LOT_NUMBER VARCHAR2 (30)
ENCUMBRANCE_ACCOUNT NUMBER

ENCUMBRANCE_AMOUNT NUMBER

SHIPMENT_NUMBER VARCHAR2 (30)
TRANSFER_COST NUMBER

TRANSPORTATION_COST NUMBER

TRANSPORTATION_ACCOUNT NUMBER

FREIGHT_CODE VARCHAR2 (30)
CONTAINERS NUMBER

WAYBILL_AIRBILL VARCHAR2 (20)
EXPECTED_ARRIVAL_DATE DATE

NEW_AVERAGE_COST NUMBER

VALUE_CHANGE NUMBER

PERCENTAGE_CHANGE NUMBER

MATERIAL_ALLOCATION_TEMP_ID NUMBER

DEMAND_SOURCE_HEADER_ID NUMBER

DEMAND_SOURCE_LINE VARCHAR2 (30)
DEMAND_SOURCE_DELIVERY VARCHAR2 (30)
ITEM_SEGMENTS VARCHAR2 (240)
ITEM_DESCRIPTION VARCHAR2 (240)
ITEM_TRX_ENABLED_FLAG VARCHAR2 (1)
ITEM_LOCATION_CONTROL_CODE NUMBER

ITEM_RESTRICT_SUBINV_CODE NUMBER

ITEM_RESTRICT_LOCATORS_CODE NUMBER

ITEM_REVISION_QTY_CONTROL_CODE NUMBER

ITEM_PRIMARY_UOM_CODE VARCHAR2 (3)
ITEM_UOM_CLASS VARCHAR2 (10)
ITEM_SHELF_LIFE_CODE NUMBER

ITEM_SHELF_LIFE_DAYS NUMBER

ITEM_LOT_CONTROL_CODE NUMBER

ITEM_SERIAL_CONTROL_CODE NUMBER

ITEM_INVENTORY_ASSET_FLAG VARCHAR2 (1)
ALLOWED_UNITS_LOOKUP_CODE NUMBER

DEPARTMENT_ID NUMBER

DEPARTMENT_CODE VARCHAR2 (10)
WIP_SUPPLY_TYPE NUMBER

SUPPLY_SUBINVENTORY VARCHAR2 (10)
SUPPLY_LOCATOR_ID NUMBER

VALID_SUBINVENTORY_FLAG VARCHAR2 (1)
VALID_LOCATOR_FLAG VARCHAR2 (1)
LOCATOR_SEGMENTS VARCHAR2 (240)
CURRENT_LOCATOR_CONTROL_CODE NUMBER

NUMBER_OF_LOTS_ENTERED NUMBER

WIP_COMMIT_FLAG VARCHAR2 (1)
NEXT_LOT_NUMBER VARCHAR2 (30)
LOT_ALPHA_PREFIX VARCHAR2 (30)
NEXT_SERIAL_NUMBER VARCHAR2 (30)
SERIAL_ALPHA_PREFIX VARCHAR2 (30)
SHIPPABLE_FLAG VARCHAR2 (1)
POSTING_FLAG VARCHAR2 (1)
REQUIRED_FLAG VARCHAR2 (1)
PROCESS_FLAG VARCHAR2 (1)
ERROR_CODE VARCHAR2 (240)
ERROR_EXPLANATION VARCHAR2 (240)
MOVEMENT_ID NUMBER

RESERVATION_QUANTITY NUMBER

SHIPPED_QUANTITY NUMBER

TRANSACTION_LINE_NUMBER NUMBER

TO_TASK_ID NUMBER

SOURCE_TASK_ID NUMBER

SOURCE_PROJECT_ID NUMBER

PA_EXPENDITURE_ORG_ID NUMBER

TO_PROJECT_ID NUMBER

EXPENDITURE_TYPE VARCHAR2 (30)
FINAL_COMPLETION_FLAG VARCHAR2 (1)
TRANSFER_PERCENTAGE NUMBER

TRANSACTION_SEQUENCE_ID NUMBER

MATERIAL_ACCOUNT NUMBER

MATERIAL_OVERHEAD_ACCOUNT NUMBER

RESOURCE_ACCOUNT NUMBER

OUTSIDE_PROCESSING_ACCOUNT NUMBER

OVERHEAD_ACCOUNT NUMBER

FLOW_SCHEDULE VARCHAR2 (1)
DEMAND_CLASS VARCHAR2 (30)
QA_COLLECTION_ID NUMBER

KANBAN_CARD_ID NUMBER

OVERCOMPLETION_TRANSACTION_ID NUMBER

OVERCOMPLETION_PRIMARY_QTY NUMBER

OVERCOMPLETION_TRANSACTION_QTY NUMBER

SCHEDULED_PAYBACK_DATE DATE

LINE_TYPE_CODE NUMBER

PARENT_TRANSACTION_TEMP_ID NUMBER

PUT_AWAY_RULE_ID NUMBER

PICK_RULE_ID NUMBER

COMMON_BOM_SEQ_ID NUMBER

COMMON_ROUTING_SEQ_ID NUMBER

COST_TYPE_ID NUMBER

ORG_COST_GROUP_ID NUMBER

MOVE_ORDER_LINE_ID NUMBER

TASK_GROUP_ID NUMBER

PICK_SLIP_NUMBER NUMBER

RESERVATION_ID NUMBER

TRANSACTION_STATUS NUMBER

STANDARD_OPERATION_ID NUMBER

TASK_PRIORITY NUMBER

WMS_TASK_TYPE NUMBER

PARENT_LINE_ID NUMBER

INSPECTION_STATUS NUMBER

SOURCE_ORGANIZATION_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LINE_ID
,      HEADER_ID
,      LINE_NUMBER
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REVISION
,      FROM_SUBINVENTORY_ID
,      FROM_SUBINVENTORY_CODE
,      FROM_LOCATOR_ID
,      TO_SUBINVENTORY_CODE
,      TO_SUBINVENTORY_ID
,      TO_LOCATOR_ID
,      TO_ACCOUNT_ID
,      LOT_NUMBER
,      SERIAL_NUMBER_START
,      SERIAL_NUMBER_END
,      UOM_CODE
,      QUANTITY
,      QUANTITY_DELIVERED
,      QUANTITY_DETAILED
,      DATE_REQUIRED
,      REASON_ID
,      REFERENCE
,      REFERENCE_TYPE_CODE
,      REFERENCE_ID
,      PROJECT_ID
,      TASK_ID
,      TRANSACTION_HEADER_ID
,      LINE_STATUS
,      STATUS_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      TXN_SOURCE_ID
,      TXN_SOURCE_LINE_ID
,      TXN_SOURCE_LINE_DETAIL_ID
,      TRANSACTION_TYPE_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      PRIMARY_QUANTITY
,      TO_ORGANIZATION_ID
,      PUT_AWAY_STRATEGY_ID
,      PICK_STRATEGY_ID
,      UNIT_NUMBER
,      SHIP_TO_LOCATION_ID
,      FROM_COST_GROUP_ID
,      TO_COST_GROUP_ID
,      LPN_ID
,      TO_LPN_ID
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      TRANSACTION_MODE
,      LOCK_FLAG
,      TRANSACTION_COST
,      TRANSACTION_ACTION_ID
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_NAME
,      TRANSACTION_DATE
,      ACCT_PERIOD_ID
,      DISTRIBUTION_ACCOUNT_ID
,      REQUISITION_LINE_ID
,      REQUISITION_DISTRIBUTION_ID
,      LOT_EXPIRATION_DATE
,      SERIAL_NUMBER
,      RECEIVING_DOCUMENT
,      DEMAND_ID
,      RCV_TRANSACTION_ID
,      MOVE_TRANSACTION_ID
,      COMPLETION_TRANSACTION_ID
,      WIP_ENTITY_TYPE
,      SCHEDULE_ID
,      REPETITIVE_LINE_ID
,      EMPLOYEE_CODE
,      PRIMARY_SWITCH
,      SCHEDULE_UPDATE_CODE
,      SETUP_TEARDOWN_CODE
,      ITEM_ORDERING
,      NEGATIVE_REQ_FLAG
,      OPERATION_SEQ_NUM
,      PICKING_LINE_ID
,      TRX_SOURCE_DELIVERY_ID
,      PHYSICAL_ADJUSTMENT_ID
,      CYCLE_COUNT_ID
,      RMA_LINE_ID
,      CUSTOMER_SHIP_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      USSGL_TRANSACTION_CODE
,      VENDOR_LOT_NUMBER
,      ENCUMBRANCE_ACCOUNT
,      ENCUMBRANCE_AMOUNT
,      SHIPMENT_NUMBER
,      TRANSFER_COST
,      TRANSPORTATION_COST
,      TRANSPORTATION_ACCOUNT
,      FREIGHT_CODE
,      CONTAINERS
,      WAYBILL_AIRBILL
,      EXPECTED_ARRIVAL_DATE
,      NEW_AVERAGE_COST
,      VALUE_CHANGE
,      PERCENTAGE_CHANGE
,      MATERIAL_ALLOCATION_TEMP_ID
,      DEMAND_SOURCE_HEADER_ID
,      DEMAND_SOURCE_LINE
,      DEMAND_SOURCE_DELIVERY
,      ITEM_SEGMENTS
,      ITEM_DESCRIPTION
,      ITEM_TRX_ENABLED_FLAG
,      ITEM_LOCATION_CONTROL_CODE
,      ITEM_RESTRICT_SUBINV_CODE
,      ITEM_RESTRICT_LOCATORS_CODE
,      ITEM_REVISION_QTY_CONTROL_CODE
,      ITEM_PRIMARY_UOM_CODE
,      ITEM_UOM_CLASS
,      ITEM_SHELF_LIFE_CODE
,      ITEM_SHELF_LIFE_DAYS
,      ITEM_LOT_CONTROL_CODE
,      ITEM_SERIAL_CONTROL_CODE
,      ITEM_INVENTORY_ASSET_FLAG
,      ALLOWED_UNITS_LOOKUP_CODE
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      WIP_SUPPLY_TYPE
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      VALID_SUBINVENTORY_FLAG
,      VALID_LOCATOR_FLAG
,      LOCATOR_SEGMENTS
,      CURRENT_LOCATOR_CONTROL_CODE
,      NUMBER_OF_LOTS_ENTERED
,      WIP_COMMIT_FLAG
,      NEXT_LOT_NUMBER
,      LOT_ALPHA_PREFIX
,      NEXT_SERIAL_NUMBER
,      SERIAL_ALPHA_PREFIX
,      SHIPPABLE_FLAG
,      POSTING_FLAG
,      REQUIRED_FLAG
,      PROCESS_FLAG
,      ERROR_CODE
,      ERROR_EXPLANATION
,      MOVEMENT_ID
,      RESERVATION_QUANTITY
,      SHIPPED_QUANTITY
,      TRANSACTION_LINE_NUMBER
,      TO_TASK_ID
,      SOURCE_TASK_ID
,      SOURCE_PROJECT_ID
,      PA_EXPENDITURE_ORG_ID
,      TO_PROJECT_ID
,      EXPENDITURE_TYPE
,      FINAL_COMPLETION_FLAG
,      TRANSFER_PERCENTAGE
,      TRANSACTION_SEQUENCE_ID
,      MATERIAL_ACCOUNT
,      MATERIAL_OVERHEAD_ACCOUNT
,      RESOURCE_ACCOUNT
,      OUTSIDE_PROCESSING_ACCOUNT
,      OVERHEAD_ACCOUNT
,      FLOW_SCHEDULE
,      DEMAND_CLASS
,      QA_COLLECTION_ID
,      KANBAN_CARD_ID
,      OVERCOMPLETION_TRANSACTION_ID
,      OVERCOMPLETION_PRIMARY_QTY
,      OVERCOMPLETION_TRANSACTION_QTY
,      SCHEDULED_PAYBACK_DATE
,      LINE_TYPE_CODE
,      PARENT_TRANSACTION_TEMP_ID
,      PUT_AWAY_RULE_ID
,      PICK_RULE_ID
,      COMMON_BOM_SEQ_ID
,      COMMON_ROUTING_SEQ_ID
,      COST_TYPE_ID
,      ORG_COST_GROUP_ID
,      MOVE_ORDER_LINE_ID
,      TASK_GROUP_ID
,      PICK_SLIP_NUMBER
,      RESERVATION_ID
,      TRANSACTION_STATUS
,      STANDARD_OPERATION_ID
,      TASK_PRIORITY
,      WMS_TASK_TYPE
,      PARENT_LINE_ID
,      INSPECTION_STATUS
,      SOURCE_ORGANIZATION_ID
FROM APPS.WMS_COST_GROUPS_INPUT_V;

Dependencies

[top of page]

APPS.WMS_COST_GROUPS_INPUT_V references the following:

SchemaAPPS
SynonymMTL_INTERORG_PARAMETERS
SynonymMTL_MATERIAL_TRANSACTIONS_TEMP
SynonymMTL_SERIAL_NUMBERS
SynonymMTL_SERIAL_NUMBERS_TEMP
SynonymMTL_TRANSACTION_LOTS_TEMP
SynonymMTL_TRANSACTION_TYPES
SynonymMTL_TXN_REQUEST_LINES
PL/SQL PackageWMS_COSTGROUPENGINE_PVT - show dependent code
APPS.WMS_COST_GROUPS_INPUT_V is referenced by following:

SchemaAPPS
Package BodyWMS_COSTGROUPENGINE_PVT - show dependent code
Package BodyWMS_STRATEGY_PVT - show dependent code