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

VIEW: APPS.PO_REQ_LINES_REF_V

Object Details
Object Name: PO_REQ_LINES_REF_V
Object Type: VIEW
Owner: APPS
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
REQ_LINE_ID NUMBER
Yes Requisition line unique identifier
REQ_LINE_NUM NUMBER
Yes Line number
REQ_LINE_TYPE_ID NUMBER
Yes Line type
LINE_TYPE_NAME VARCHAR2 (25) Yes Line Type Name
REQ_LINE_DESCRIPTION VARCHAR2 (240) Yes Requisition Line Description
REQ_LINE_LOCATION_ID NUMBER

Requisition Line Location Identifier
BLANKET_PO_HEADER_ID NUMBER

Suggested source blanket agreement or catalog quotation header unique identifier
BLANKET_PO_LINE_NUM NUMBER

Suggested source blanket agreement or catalog quotation line number
DESTINATION_TYPE_CODE VARCHAR2 (25)
Destination type
SUBINVENTORY_BUDGET_ACCOUNT NUMBER

Subinventory Budget Account
ORG_BUDGET_ACCOUNT_ID NUMBER

Organzation Budget Account
ITEM_BUDGET_ACCOUNT_ID NUMBER

Item Budget Account
EXPENSE_AP_ACCRUAL_ACCOUNT NUMBER

Expense AP Accrual Account
INV_AP_ACCRUAL_ACCOUNT NUMBER

Inventory AP Accrual Account
INV_IPV_ACCOUNT NUMBER

Organization Inventory Price Variance Account
ORG_COST_OF_SALES_ACCOUNT NUMBER

Organization Cost of Sales Account
ORG_EXPENSE_ACCOUNT NUMBER

Organization Expense Account
ORG_MATERIAL_ACCOUNT NUMBER

Organization Material Account
ITEM_EXPENSE_ACCOUNT NUMBER

Item Expense Account
EMPLOYEE_CHARGE_ACCOUNT NUMBER (15)
Employee Charge Account
ITEM_ASSET_FLAG VARCHAR2 (1)
Item Asset Indicator
DROP_SHIPMENT VARCHAR2 (1)
Drop Shipment Indicator
DESTINATION_SUBINVENTORY VARCHAR2 (10)
Destination Sub inventory
DELIVER_TO_LOCATION_ID NUMBER
Yes Delivery Location Identifier
DELIVER_TO_LOCATION_NAME VARCHAR2 (60) Yes Delivery Location
DELIVER_TO_PERSON_ID NUMBER (9) Yes Requestor Identifier
DELIVER_TO_PERSON VARCHAR2 (240)
Requestor Name
REQ_LINE_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield segment
REQ_LINE_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment .
REQ_LINE_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment .
REQ_LINE_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment .
REQ_LINE_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment .
REQ_LINE_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment .
REQ_LINE_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment .
REQ_LINE_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment .
REQ_LINE_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment .
REQ_LINE_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment .
REQ_LINE_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment .
REQ_LINE_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment .
REQ_LINE_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment .
REQ_LINE_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment .
REQ_LINE_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment .
REQ_LINE_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment .
REQ_LINE_GLOBAL_ATTR_CATEGORY VARCHAR2 (30)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality
REQ_LINE_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality
INVENTORY_ITEM NUMBER

Inventory Item
ITEM_REVISION VARCHAR2 (3)
Inventory Item Revision
ITEM_CATEGORY NUMBER
Yes Inventory Item Category
ITEM_DESCRIPTION VARCHAR2 (240) Yes Item description
CATEGORY_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ITEM_CATEGORY_ATTRIBUTE1 VARCHAR2 (150)
Inventory Item Category
ITEM_CATEGORY_ATTRIBUTE2 VARCHAR2 (150)
Inventory Item Category
ITEM_CATEGORY_ATTRIBUTE3 VARCHAR2 (150)
Inventory Item Category
ITEM_CATEGORY_ATTRIBUTE4 VARCHAR2 (150)
Inventory Item Category
ITEM_CATEGORY_ATTRIBUTE5 VARCHAR2 (150)
Inventory Item Category
ITEM_CATEGORY_ATTRIBUTE6 VARCHAR2 (150)
Inventory Item Category
ITEM_CATEGORY_ATTRIBUTE7 VARCHAR2 (150)
Inventory Item Category
ITEM_CATEGORY_ATTRIBUTE8 VARCHAR2 (150)
Inventory Item Category
ITEM_CATEGORY_ATTRIBUTE9 VARCHAR2 (150)
Inventory Item Category
ITEM_CATEGORY_ATTRIBUTE10 VARCHAR2 (150)
Inventory Item Category
ITEM_CATEGORY_ATTRIBUTE11 VARCHAR2 (150)
Inventory Item Category
ITEM_CATEGORY_ATTRIBUTE12 VARCHAR2 (150)
Inventory Item Category
ITEM_CATEGORY_ATTRIBUTE13 VARCHAR2 (150)
Inventory Item Category
ITEM_CATEGORY_ATTRIBUTE14 VARCHAR2 (150)
Inventory Item Category
ITEM_CATEGORY_ATTRIBUTE15 VARCHAR2 (150)
Inventory Item Category
ITEM_CATEGORY_SEGMENT1 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT2 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT3 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT4 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT5 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT6 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT7 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT8 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT9 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT10 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT11 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT12 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT13 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT14 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT15 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT16 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT17 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT18 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT19 VARCHAR2 (40)
Key flexfield segment
ITEM_CATEGORY_SEGMENT20 VARCHAR2 (40)
Key flexfield segment
SHIP_TO_ORGANIZATION_ID NUMBER

Ship-To Organization Identifier
SHIP_TO_ORGANIZATION_CODE VARCHAR2 (3)
Ship-To Organization Code
DESTINATION_ORGANIZATION_ID NUMBER

Destination Organization Identifier
DESTINATION_ORGANIZATION_CODE VARCHAR2 (3)
Destination Organization Code
WIP_ENTITY_ID NUMBER

WIP Job/Repetitive Assembly Identifier
WIP_ENTITY_NAME VARCHAR2 (240)
Job/Schedule
WIP_LINE_ID NUMBER

Line
WIP_OPERATION_SEQ_NUM NUMBER

Operation Sequence
WIP_REPETITIVE_SCHEDULE_ID NUMBER

Schedule Identifier
WIP_RESOURCE_SEQ_NUM NUMBER

WIP Resource Sequence Number
BOM_RESOURCE_ID NUMBER

BOM Resource Identifier
RESOURCE_CODE VARCHAR2 (10)
Resource
ENTERED_CURRENCY_CODE VARCHAR2 (15)
Currency code
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
UNIT_PRICE NUMBER

Unit Price
Query Text

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


SELECT REQ_LINE_ID
,      REQ_LINE_NUM
,      REQ_LINE_TYPE_ID
,      LINE_TYPE_NAME
,      REQ_LINE_DESCRIPTION
,      REQ_LINE_LOCATION_ID
,      BLANKET_PO_HEADER_ID
,      BLANKET_PO_LINE_NUM
,      DESTINATION_TYPE_CODE
,      SUBINVENTORY_BUDGET_ACCOUNT
,      ORG_BUDGET_ACCOUNT_ID
,      ITEM_BUDGET_ACCOUNT_ID
,      EXPENSE_AP_ACCRUAL_ACCOUNT
,      INV_AP_ACCRUAL_ACCOUNT
,      INV_IPV_ACCOUNT
,      ORG_COST_OF_SALES_ACCOUNT
,      ORG_EXPENSE_ACCOUNT
,      ORG_MATERIAL_ACCOUNT
,      ITEM_EXPENSE_ACCOUNT
,      EMPLOYEE_CHARGE_ACCOUNT
,      ITEM_ASSET_FLAG
,      DROP_SHIPMENT
,      DESTINATION_SUBINVENTORY
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_LOCATION_NAME
,      DELIVER_TO_PERSON_ID
,      DELIVER_TO_PERSON
,      REQ_LINE_ATTRIBUTE_CATEGORY
,      REQ_LINE_ATTRIBUTE1
,      REQ_LINE_ATTRIBUTE2
,      REQ_LINE_ATTRIBUTE3
,      REQ_LINE_ATTRIBUTE4
,      REQ_LINE_ATTRIBUTE5
,      REQ_LINE_ATTRIBUTE6
,      REQ_LINE_ATTRIBUTE7
,      REQ_LINE_ATTRIBUTE8
,      REQ_LINE_ATTRIBUTE9
,      REQ_LINE_ATTRIBUTE10
,      REQ_LINE_ATTRIBUTE11
,      REQ_LINE_ATTRIBUTE12
,      REQ_LINE_ATTRIBUTE13
,      REQ_LINE_ATTRIBUTE14
,      REQ_LINE_ATTRIBUTE15
,      REQ_LINE_GLOBAL_ATTR_CATEGORY
,      REQ_LINE_GLOBAL_ATTRIBUTE1
,      REQ_LINE_GLOBAL_ATTRIBUTE2
,      REQ_LINE_GLOBAL_ATTRIBUTE3
,      REQ_LINE_GLOBAL_ATTRIBUTE4
,      REQ_LINE_GLOBAL_ATTRIBUTE5
,      REQ_LINE_GLOBAL_ATTRIBUTE6
,      REQ_LINE_GLOBAL_ATTRIBUTE7
,      REQ_LINE_GLOBAL_ATTRIBUTE8
,      REQ_LINE_GLOBAL_ATTRIBUTE9
,      REQ_LINE_GLOBAL_ATTRIBUTE10
,      REQ_LINE_GLOBAL_ATTRIBUTE11
,      REQ_LINE_GLOBAL_ATTRIBUTE12
,      REQ_LINE_GLOBAL_ATTRIBUTE13
,      REQ_LINE_GLOBAL_ATTRIBUTE14
,      REQ_LINE_GLOBAL_ATTRIBUTE15
,      REQ_LINE_GLOBAL_ATTRIBUTE16
,      REQ_LINE_GLOBAL_ATTRIBUTE17
,      REQ_LINE_GLOBAL_ATTRIBUTE18
,      REQ_LINE_GLOBAL_ATTRIBUTE19
,      REQ_LINE_GLOBAL_ATTRIBUTE20
,      INVENTORY_ITEM
,      ITEM_REVISION
,      ITEM_CATEGORY
,      ITEM_DESCRIPTION
,      CATEGORY_ATTRIBUTE_CATEGORY
,      ITEM_CATEGORY_ATTRIBUTE1
,      ITEM_CATEGORY_ATTRIBUTE2
,      ITEM_CATEGORY_ATTRIBUTE3
,      ITEM_CATEGORY_ATTRIBUTE4
,      ITEM_CATEGORY_ATTRIBUTE5
,      ITEM_CATEGORY_ATTRIBUTE6
,      ITEM_CATEGORY_ATTRIBUTE7
,      ITEM_CATEGORY_ATTRIBUTE8
,      ITEM_CATEGORY_ATTRIBUTE9
,      ITEM_CATEGORY_ATTRIBUTE10
,      ITEM_CATEGORY_ATTRIBUTE11
,      ITEM_CATEGORY_ATTRIBUTE12
,      ITEM_CATEGORY_ATTRIBUTE13
,      ITEM_CATEGORY_ATTRIBUTE14
,      ITEM_CATEGORY_ATTRIBUTE15
,      ITEM_CATEGORY_SEGMENT1
,      ITEM_CATEGORY_SEGMENT2
,      ITEM_CATEGORY_SEGMENT3
,      ITEM_CATEGORY_SEGMENT4
,      ITEM_CATEGORY_SEGMENT5
,      ITEM_CATEGORY_SEGMENT6
,      ITEM_CATEGORY_SEGMENT7
,      ITEM_CATEGORY_SEGMENT8
,      ITEM_CATEGORY_SEGMENT9
,      ITEM_CATEGORY_SEGMENT10
,      ITEM_CATEGORY_SEGMENT11
,      ITEM_CATEGORY_SEGMENT12
,      ITEM_CATEGORY_SEGMENT13
,      ITEM_CATEGORY_SEGMENT14
,      ITEM_CATEGORY_SEGMENT15
,      ITEM_CATEGORY_SEGMENT16
,      ITEM_CATEGORY_SEGMENT17
,      ITEM_CATEGORY_SEGMENT18
,      ITEM_CATEGORY_SEGMENT19
,      ITEM_CATEGORY_SEGMENT20
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_ORGANIZATION_CODE
,      WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      WIP_LINE_ID
,      WIP_OPERATION_SEQ_NUM
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_RESOURCE_SEQ_NUM
,      BOM_RESOURCE_ID
,      RESOURCE_CODE
,      ENTERED_CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      UNIT_PRICE
FROM APPS.PO_REQ_LINES_REF_V;

Dependencies

[top of page]

APPS.PO_REQ_LINES_REF_V references the following:

SchemaAPPS
SynonymBOM_RESOURCES
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
PL/SQL PackageFND_PROFILE - show dependent code
SynonymGL_LEDGERS
ViewHR_EMPLOYEES
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_CATEGORIES
SynonymMTL_DEFAULT_CATEGORY_SETS
SynonymMTL_ITEM_CATEGORIES
SynonymMTL_PARAMETERS
SynonymMTL_SECONDARY_INVENTORIES
SynonymMTL_SYSTEM_ITEMS
ViewPER_EMPLOYEES_CURRENT_X
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_LINE_TYPES
SynonymPO_REQUISITION_HEADERS_ALL
SynonymPO_REQUISITION_LINES_ALL
SynonymPO_SYSTEM_PARAMETERS_ALL
SynonymWIP_ENTITIES
APPS.PO_REQ_LINES_REF_V is referenced by following:

SchemaAPPS
Package BodyXLA_00201_AAD_S_000004_BC_PKG - show dependent code
Package BodyXLA_00201_AAD_S_000005_BC_PKG - show dependent code