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

VIEW: APPS.ASO_PVT_QUOTE_LINES_BALI_V

Object Details
Object Name: ASO_PVT_QUOTE_LINES_BALI_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewASO.ASO_PVT_QUOTE_LINES_BALI_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
ROW_ID ROWID (10)
QUOTE_LINE_ID NUMBER
Yes
UI_LINE_NUMBER VARCHAR2 (4000)
QUOTE_HEADER_ID NUMBER
Yes
ORG_ID NUMBER

Organization identifier
LINE_CATEGORY_CODE VARCHAR2 (30)
ITEM_TYPE_CODE VARCHAR2 (30)
INVENTORY_ITEM_TYPE VARCHAR2 (30)
LINE_NUMBER NUMBER

ORDER_LINE_TYPE_ID NUMBER

ORGANIZATION_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
INVENTORY_ITEM VARCHAR2 (40)
PADDED_CONCATENATED_SEGMENTS VARCHAR2 (40)
ITEM_DESCRIPTION VARCHAR2 (240)
INDENTED_ITEM_DESCRIPTION VARCHAR2 (4000)
QUANTITY NUMBER
Yes
UOM_CODE VARCHAR2 (3) Yes
PRICE_LIST_ID NUMBER

PRICE_LIST_LINE_ID NUMBER

CURRENCY_CODE VARCHAR2 (15)
LINE_LIST_PRICE NUMBER

LINE_ADJUSTED_AMOUNT NUMBER

LINE_ADJUSTED_PERCENT NUMBER

LINE_QUOTE_PRICE NUMBER

EXTENDED_LIST_PRICE NUMBER

EXTENDED_ADJUSTED_AMOUNT NUMBER

EXTENDED_SELLING_PRICE NUMBER

START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

INVOICE_TO_PARTY_SITE_ID NUMBER

INVOICE_TO_PARTY_ID NUMBER

INVOICE_TO_CUST_PARTY_ID NUMBER

MARKETING_SOURCE_CODE_ID NUMBER

RELATED_ITEM_ID NUMBER

ITEM_RELATIONSHIP_TYPE VARCHAR2 (15)
ACCOUNTING_RULE_ID NUMBER

INVOICING_RULE_ID NUMBER

SPLIT_SHIPMENT_FLAG VARCHAR2 (1)
BACKORDER_FLAG VARCHAR2 (1)
SECURITY_GROUP_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER

INVOICE_TO_CUST_ACCOUNT_ID NUMBER

MINISITE_ID NUMBER

SECTION_ID NUMBER

PRICED_PRICE_LIST_ID NUMBER

AGREEMENT_ID NUMBER

COMMITMENT_ID NUMBER

DISPLAY_ARITHMETIC_OPERATOR VARCHAR2 (30)
LINE_TYPE_SOURCE_FLAG VARCHAR2 (1)
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (240)
ATTRIBUTE17 VARCHAR2 (240)
ATTRIBUTE18 VARCHAR2 (240)
ATTRIBUTE19 VARCHAR2 (240)
ATTRIBUTE20 VARCHAR2 (240)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
SELLING_PRICE_CHANGE VARCHAR2 (1)
RECALCULATE_FLAG VARCHAR2 (1)
PRICING_LINE_TYPE_INDICATOR VARCHAR2 (3)
END_CUSTOMER_PARTY_ID NUMBER

End Customer Party Identifier
END_CUSTOMER_CUST_PARTY_ID NUMBER

End Customer Cust Party Identifier
END_CUSTOMER_PARTY_SITE_ID NUMBER

End Customer Party Site Identifier
END_CUSTOMER_CUST_ACCOUNT_ID NUMBER

End Customer Cust Account Identifier
CHARGE_PERIODICITY_CODE VARCHAR2 (3)
SHIP_MODEL_COMPLETE_FLAG VARCHAR2 (1)
LINE_PAYNOW_CHARGES NUMBER

Line Paynow Charges
LINE_PAYNOW_TAX NUMBER

Line Paynow Tax
LINE_PAYNOW_SUBTOTAL NUMBER

Line Paynow Subtotal
CHARGE_PERIODICITY_MEANING VARCHAR2 (25)
Charge Periodicity Meaning
QUOTE_LINE_DETAIL_ID NUMBER

CONFIG_HEADER_ID NUMBER

CONFIG_REVISION_NUM NUMBER

CONFIG_ITEM_ID NUMBER

COMPLETE_CONFIGURATION_FLAG VARCHAR2 (1)
VALID_CONFIGURATION_FLAG VARCHAR2 (1)
COMPONENT_CODE VARCHAR2 (1200)
SERVICE_COTERMINATE_FLAG VARCHAR2 (1)
SERVICE_DURATION NUMBER

SERVICE_UNIT_SELLING_PERCENT NUMBER

SERVICE_UNIT_LIST_PERCENT NUMBER

SERVICE_NUMBER NUMBER

SERVICE_PERIOD VARCHAR2 (3)
SERVICE_REF_TYPE_CODE VARCHAR2 (30)
SERVICE_REF_ORDER_NUMBER NUMBER

SERVICE_REF_LINE_NUMBER NUMBER

SERVICE_REF_LINE_ID NUMBER

SERVICE_REF_SYSTEM_ID NUMBER

UNIT_PERCENT_BASE_PRICE NUMBER

SERVICE_REF_OPTION_NUMB NUMBER

SERVICE_REF_SHIPMENT_NUMB NUMBER

RETURN_REF_TYPE VARCHAR2 (30)
RETURN_REF_HEADER_ID NUMBER

RETURN_REF_LINE_ID NUMBER

RETURN_REASON_CODE VARCHAR2 (240)
REF_TYPE_CODE VARCHAR2 (30)
REF_LINE_ID NUMBER

INSTANCE_ID NUMBER

BOM_SORT_ORDER VARCHAR2 (480)
CONFIG_DELTA NUMBER

CONFIG_INSTANCE_NAME VARCHAR2 (255)
SERVICEABLE_PRODUCT_FLAG VARCHAR2 (1)
SERVICE_ITEM_FLAG VARCHAR2 (1)
TOP_MODEL_LINE_ID NUMBER

ATO_LINE_ID NUMBER

COMPONENT_SEQUENCE_ID NUMBER

SHIP_QUOTE_PRICE NUMBER

MODEL_STATUS VARCHAR2 (80)
For model status display
CONFIG_MODEL_TYPE VARCHAR2 (30)
Query Text

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


SELECT ROW_ID
,      QUOTE_LINE_ID
,      UI_LINE_NUMBER
,      QUOTE_HEADER_ID
,      ORG_ID
,      LINE_CATEGORY_CODE
,      ITEM_TYPE_CODE
,      INVENTORY_ITEM_TYPE
,      LINE_NUMBER
,      ORDER_LINE_TYPE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM
,      PADDED_CONCATENATED_SEGMENTS
,      ITEM_DESCRIPTION
,      INDENTED_ITEM_DESCRIPTION
,      QUANTITY
,      UOM_CODE
,      PRICE_LIST_ID
,      PRICE_LIST_LINE_ID
,      CURRENCY_CODE
,      LINE_LIST_PRICE
,      LINE_ADJUSTED_AMOUNT
,      LINE_ADJUSTED_PERCENT
,      LINE_QUOTE_PRICE
,      EXTENDED_LIST_PRICE
,      EXTENDED_ADJUSTED_AMOUNT
,      EXTENDED_SELLING_PRICE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      INVOICE_TO_PARTY_SITE_ID
,      INVOICE_TO_PARTY_ID
,      INVOICE_TO_CUST_PARTY_ID
,      MARKETING_SOURCE_CODE_ID
,      RELATED_ITEM_ID
,      ITEM_RELATIONSHIP_TYPE
,      ACCOUNTING_RULE_ID
,      INVOICING_RULE_ID
,      SPLIT_SHIPMENT_FLAG
,      BACKORDER_FLAG
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      INVOICE_TO_CUST_ACCOUNT_ID
,      MINISITE_ID
,      SECTION_ID
,      PRICED_PRICE_LIST_ID
,      AGREEMENT_ID
,      COMMITMENT_ID
,      DISPLAY_ARITHMETIC_OPERATOR
,      LINE_TYPE_SOURCE_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      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
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE_CATEGORY
,      SELLING_PRICE_CHANGE
,      RECALCULATE_FLAG
,      PRICING_LINE_TYPE_INDICATOR
,      END_CUSTOMER_PARTY_ID
,      END_CUSTOMER_CUST_PARTY_ID
,      END_CUSTOMER_PARTY_SITE_ID
,      END_CUSTOMER_CUST_ACCOUNT_ID
,      CHARGE_PERIODICITY_CODE
,      SHIP_MODEL_COMPLETE_FLAG
,      LINE_PAYNOW_CHARGES
,      LINE_PAYNOW_TAX
,      LINE_PAYNOW_SUBTOTAL
,      CHARGE_PERIODICITY_MEANING
,      QUOTE_LINE_DETAIL_ID
,      CONFIG_HEADER_ID
,      CONFIG_REVISION_NUM
,      CONFIG_ITEM_ID
,      COMPLETE_CONFIGURATION_FLAG
,      VALID_CONFIGURATION_FLAG
,      COMPONENT_CODE
,      SERVICE_COTERMINATE_FLAG
,      SERVICE_DURATION
,      SERVICE_UNIT_SELLING_PERCENT
,      SERVICE_UNIT_LIST_PERCENT
,      SERVICE_NUMBER
,      SERVICE_PERIOD
,      SERVICE_REF_TYPE_CODE
,      SERVICE_REF_ORDER_NUMBER
,      SERVICE_REF_LINE_NUMBER
,      SERVICE_REF_LINE_ID
,      SERVICE_REF_SYSTEM_ID
,      UNIT_PERCENT_BASE_PRICE
,      SERVICE_REF_OPTION_NUMB
,      SERVICE_REF_SHIPMENT_NUMB
,      RETURN_REF_TYPE
,      RETURN_REF_HEADER_ID
,      RETURN_REF_LINE_ID
,      RETURN_REASON_CODE
,      REF_TYPE_CODE
,      REF_LINE_ID
,      INSTANCE_ID
,      BOM_SORT_ORDER
,      CONFIG_DELTA
,      CONFIG_INSTANCE_NAME
,      SERVICEABLE_PRODUCT_FLAG
,      SERVICE_ITEM_FLAG
,      TOP_MODEL_LINE_ID
,      ATO_LINE_ID
,      COMPONENT_SEQUENCE_ID
,      SHIP_QUOTE_PRICE
,      MODEL_STATUS
,      CONFIG_MODEL_TYPE
FROM APPS.ASO_PVT_QUOTE_LINES_BALI_V;

Dependencies

[top of page]

APPS.ASO_PVT_QUOTE_LINES_BALI_V references the following:

SchemaAPPS
PL/SQL PackageASO_LINE_NUM_INT - show dependent code
ViewASO_PVT_QUOTE_LINES_NUM_V
PL/SQL PackageFND_PROFILE - show dependent code
APPS.ASO_PVT_QUOTE_LINES_BALI_V is referenced by following:

SchemaAPPS
Package BodyASO_ATP_INT - show dependent code
Package BodyASO_LINE_NUM_INT - show dependent code
Package BodyASO_QUOTE_PUB_W - show dependent code
Package BodyASO_UTILITY_PVT - show dependent code