eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.AST_PURCH_LINES_V

Object Details

Object Name:	AST_PURCH_LINES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
LEAD_LINE_ID	NUMBER		Yes
LEAD_ID	NUMBER		Yes
INTEREST_TYPE_ID	NUMBER
PRIMARY_INTEREST_CODE_ID	NUMBER
SECONDARY_INTEREST_CODE_ID	NUMBER
INTEREST_STATUS_CODE	VARCHAR2	(30)
INVENTORY_ITEM_ID	NUMBER
ORGANIZATION_ID	NUMBER
UOM_CODE	VARCHAR2	(3)
QUANTITY	NUMBER
SHIP_DATE	DATE
TOTAL_AMOUNT	NUMBER
QUOTED_LINE_FLAG	VARCHAR2	(1)
ORIGINAL_LEAD_LINE_ID	NUMBER
INTEREST_TYPE	VARCHAR2	(80)
PRIMARY_INTEREST_CODE	VARCHAR2	(100)
SECONDARY_INTEREST_CODE	VARCHAR2	(100)
PRICE	NUMBER
PRICE_VOLUME_MARGIN	NUMBER
PF_ITEM_ID	NUMBER
PF_ORGANIZATION_ID	NUMBER

Query Text

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


SELECT LEAD_LINE_ID
,      LEAD_ID
,      INTEREST_TYPE_ID
,      PRIMARY_INTEREST_CODE_ID
,      SECONDARY_INTEREST_CODE_ID
,      INTEREST_STATUS_CODE
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      UOM_CODE
,      QUANTITY
,      SHIP_DATE
,      TOTAL_AMOUNT
,      QUOTED_LINE_FLAG
,      ORIGINAL_LEAD_LINE_ID
,      INTEREST_TYPE
,      PRIMARY_INTEREST_CODE
,      SECONDARY_INTEREST_CODE
,      PRICE
,      PRICE_VOLUME_MARGIN
,      PF_ITEM_ID
,      PF_ORGANIZATION_ID
FROM APPS.AST_PURCH_LINES_V;

Dependencies

[top of page]

APPS.AST_PURCH_LINES_V references the following:

APPS: AS_INTEREST_CODES_VL; AS_INTEREST_TYPES_VL; AS_LEAD_LINES

APPS.AST_PURCH_LINES_V is not referenced by any database object