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.SO_LINES_RMA_V

Object Details

Object Name:	SO_LINES_RMA_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OE.SO_LINES_RMA_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
LINE_ID	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
HEADER_ID	NUMBER		Yes
PARENT_LINE_ID	NUMBER
LINK_TO_LINE_ID	NUMBER
LINE_TYPE_CODE	VARCHAR2	(30)	Yes
OPTION_FLAG	VARCHAR2	(1)	Yes
OPEN_FLAG	VARCHAR2	(1)
CYCLE_ID	NUMBER
LINE_NUMBER	NUMBER
INVENTORY_ITEM_ID	NUMBER		Yes
ITEM_DESCRIPTION	VARCHAR2	(240)
BOM_ITEM_TYPE	NUMBER		Yes
COMPONENT_SEQUENCE_ID	NUMBER
ITEM_TYPE_CODE	VARCHAR2	(30)	Yes
ITEM_TYPE	VARCHAR2	(80)
ATO_FLAG	VARCHAR2	(1)	Yes
COMPONENT_CODE	VARCHAR2	(1000)
COMPONENT_SORT_CODE	VARCHAR2	(240)
ORDERED_QUANTITY	NUMBER
CANCELLED_QUANTITY	NUMBER
RECEIVED_QUANTITY	NUMBER
ACCEPTED_QUANTITY	NUMBER
ACTUAL_RECEIPT_DATE	DATE
ACTUAL_ACCEPTED_DATE	DATE
UNIT_CODE	VARCHAR2	(3)
PRICE_LIST_ID	NUMBER
ROUNDING_FACTOR	NUMBER
PRICE_ADJUSTMENTS_TOTAL	NUMBER
PRICING_METHOD_CODE	VARCHAR2	(30)
LIST_PRICE	NUMBER
LIST_PERCENT	NUMBER
SELLING_PRICE	NUMBER
SELLING_PERCENT	NUMBER
WAREHOUSE_ID	NUMBER
WAREHOUSE_CODE	VARCHAR2	(3)
SHIPPED_QUANTITY	NUMBER
DATE_REQUESTED_CURRENT	DATE
SHIP_TO_SITE_USE_ID	NUMBER
TERMS_ID	NUMBER
INVOICED_QUANTITY	NUMBER
TAX_EXEMPT_FLAG	VARCHAR2	(1)
TAX_EXEMPT_FLAG_DISPLAY	VARCHAR2	(4000)
TAX_EXEMPT_NUMBER_DISPLAY	VARCHAR2	(80)
TAX_EXEMPT_REASON	VARCHAR2	(30)
TAX_EXEMPT_REASON_DISPLAY	VARCHAR2	(4000)
TAX_EXEMPT_NUMBER	VARCHAR2	(80)
TAX_EXEMPT_REASON_CODE	VARCHAR2	(30)
TAX_CODE_DISPLAY	VARCHAR2	(50)
TAX_CODE	VARCHAR2	(50)
TRANSACTION_REASON_CODE	VARCHAR2	(30)
RETURN_REASON_NAME	VARCHAR2	(80)
RETURN_REFERENCE_TYPE_CODE	VARCHAR2	(30)
RETURN_REFERENCE_TYPE_NAME	VARCHAR2	(80)
RETURN_REFERENCE_ID	NUMBER
CREDIT_INVOICE_LINE_ID	NUMBER
CREDIT_TO_INVOICE	VARCHAR2	(20)
INSPECTION_REQUIRED_FLAG	VARCHAR2	(1)
RETURN_FOR_REPAIR_FLAG	VARCHAR2	(1)
REFERENCE_NUMBER	VARCHAR2	(50)
REFERENCE_HEADER_ID	NUMBER
REFERENCE_LINE_NUMBER	NUMBER
REFERENCE_SHIPMENT_NUMBER	NUMBER
REFERENCE_OPTION_NUMBER	NUMBER
REFERENCE_CREATION_DATE	DATE
ORIGINAL_ORDERED_QUANTITY	NUMBER
PRICING_CONTEXT	VARCHAR2	(30)
PRICING_ATTRIBUTE1	VARCHAR2	(150)
PRICING_ATTRIBUTE2	VARCHAR2	(150)
PRICING_ATTRIBUTE3	VARCHAR2	(150)
PRICING_ATTRIBUTE4	VARCHAR2	(150)
PRICING_ATTRIBUTE5	VARCHAR2	(150)
PRICING_ATTRIBUTE6	VARCHAR2	(150)
PRICING_ATTRIBUTE7	VARCHAR2	(150)
PRICING_ATTRIBUTE8	VARCHAR2	(150)
PRICING_ATTRIBUTE9	VARCHAR2	(150)
PRICING_ATTRIBUTE10	VARCHAR2	(150)
PRICING_ATTRIBUTE11	VARCHAR2	(150)
PRICING_ATTRIBUTE12	VARCHAR2	(150)
PRICING_ATTRIBUTE13	VARCHAR2	(150)
PRICING_ATTRIBUTE14	VARCHAR2	(150)
PRICING_ATTRIBUTE15	VARCHAR2	(150)
S1	NUMBER
S1_DATE	DATE
S2	NUMBER
S2_DATE	DATE
S3	NUMBER
S3_DATE	DATE
S4	NUMBER
S4_DATE	DATE
S5	NUMBER
S5_DATE	DATE
S6	NUMBER
S6_DATE	DATE
S7	NUMBER
S7_DATE	DATE
S8	NUMBER
S8_DATE	DATE
S9	NUMBER
S9_DATE	DATE
S10	NUMBER
S10_DATE	DATE
S11	NUMBER
S11_DATE	DATE
S12	NUMBER
S12_DATE	DATE
S13	NUMBER
S13_DATE	DATE
S14	NUMBER
S14_DATE	DATE
S15	NUMBER
S15_DATE	DATE
S16	NUMBER
S16_DATE	DATE
S17	NUMBER
S17_DATE	DATE
S18	NUMBER
S18_DATE	DATE
S19	NUMBER
S19_DATE	DATE
S20	NUMBER
S20_DATE	DATE
S21	NUMBER
S21_DATE	DATE
S22	NUMBER
S22_DATE	DATE
S23	NUMBER
S23_DATE	DATE
S24	NUMBER
S24_DATE	DATE
S25	NUMBER
S25_DATE	DATE
S26	NUMBER
S26_DATE	DATE
S27	NUMBER
S27_DATE	DATE
S28	NUMBER
S28_DATE	DATE
S29	NUMBER
S29_DATE	DATE
S30	NUMBER
S30_DATE	DATE
CONTEXT	VARCHAR2	(30)
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)
NUMBER_SVRID	NUMBER
ITEM_SVRID	NUMBER
ORDERED_QUANTITY_SVRID	NUMBER
UNIT_SVRID	NUMBER
PRICING_ATTRIBUTES_SVRID	NUMBER
LIST_PRICE_SVRID	NUMBER
SELLING_PRICE_SVRID	NUMBER
LIST_PERCENT_SVRID	NUMBER
SELLING_PERCENT_SVRID	NUMBER
WAREHOUSE_SVRID	NUMBER
DEMAND_CLASS_SVRID	NUMBER
SHIP_SET_NUMBER_SVRID	NUMBER
REQUEST_DATE_SVRID	NUMBER
PROMISE_DATE_SVRID	NUMBER
SCHEDULE_DATE_SVRID	NUMBER
SHIP_TO_SVRID	NUMBER
SHIP_TO_CONTACT_SVRID	NUMBER
SHIPMENT_PRIORITY_SVRID	NUMBER
FREIGHT_CARRIER_SVRID	NUMBER
AGREEMENT_SVRID	NUMBER
COMMITMENT_SVRID	NUMBER
PAYMENT_TERMS_SVRID	NUMBER
INVOICING_RULE_SVRID	NUMBER
ACCOUNTING_RULE_SVRID	NUMBER
TAX_EXEMPT_NUMBER_SVRID	NUMBER
TAX_EXEMPT_REASON_SVRID	NUMBER
TRANSACTION_TYPE_SVRID	NUMBER
TRANSACTION_REASON_SVRID	NUMBER
TRANSACTION_COMMENTS_SVRID	NUMBER
RETURN_REFERENCE_TYPE_SVRID	NUMBER
RETURN_REFERENCE_SVRID	NUMBER
CREDIT_INVOICE_LINE_SVRID	NUMBER
INSPECTION_REQUIRED_SVRID	NUMBER
CUSTOMER_PRODUCT_SVRID	NUMBER
CUSTOMER_PRODUCT_SERVICE_SVRID	NUMBER
SERVICE_DURATION_SVRID	NUMBER
SERVICE_START_DATE_SVRID	NUMBER
SERVICE_END_DATE_SVRID	NUMBER
SERVICE_PER_CONV_RATE_SVRID	NUMBER
SERVICE_COTERMINATE_SVRID	NUMBER
DF_SVRID	NUMBER
TAX_CODE_SVRID	NUMBER
LATEST_ACCEPTABLE_DATE_SVRID	NUMBER
ATO_LINE_ID	NUMBER
ACCOUNTING_RULE_ID	NUMBER
AGREEMENT_ID	NUMBER
COMMITMENT_ID	NUMBER
CONFIGURATION_EDITED_FLAG	VARCHAR2	(1)
CUSTOMER_PRODUCT_ID	NUMBER
CP_SERVICE_ID	NUMBER
DEMAND_CLASS_CODE	VARCHAR2	(30)
SHIP_METHOD_CODE	VARCHAR2	(30)
INVOICE_COUNT	NUMBER
QUANTITY_TO_INVOICE	NUMBER
INVOICING_RULE_ID	NUMBER
LATEST_ACCEPTABLE_DATE	DATE
ORIGINAL_SYSTEM_LINE_REFERENCE	VARCHAR2	(50)
PERCENT_BASE_PRICE	NUMBER
PRICING_DATE	DATE
REVENUE_AMOUNT	NUMBER
SCHEDULE_DATE	DATE
SERVICE_COTERMINATE_FLAG	VARCHAR2	(1)
SERVICE_DURATION	NUMBER
SERVICE_END_DATE	DATE
SERVICE_MASS_TXN_TEMP_ID	NUMBER
SERVICE_PARENT_LINE_ID	NUMBER
SERVICE_PERIOD_CONVERSION_RATE	NUMBER
SERVICE_START_DATE	DATE
SERVICED_QUANTITY	NUMBER
SHIP_MODEL_COMPLETE_FLAG	VARCHAR2	(1)
SHIP_SET_NUMBER	NUMBER
SHIP_TO_CONTACT_ID	NUMBER
SOURCE_LINE_ID	NUMBER
STANDARD_COMPONENT_FREEZE_DATE	DATE
TRANSACTION_COMMENTS	VARCHAR2	(240)
TRANSACTION_TYPE_CODE	VARCHAR2	(30)
PROMISE_DATE	DATE
SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)
SHIPMENT_SCHEDULE_LINE_ID	NUMBER
SOURCE_TYPE_CODE	VARCHAR2	(30)
SOURCE_TYPE	VARCHAR2	(80)
SOURCE_TYPE_CODE_SVRID	NUMBER
PLANNING_PRIORITY	NUMBER
PLANNING_PRIORITY_SVRID	NUMBER

Query Text

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


SELECT ROW_ID
,      LINE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      HEADER_ID
,      PARENT_LINE_ID
,      LINK_TO_LINE_ID
,      LINE_TYPE_CODE
,      OPTION_FLAG
,      OPEN_FLAG
,      CYCLE_ID
,      LINE_NUMBER
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      BOM_ITEM_TYPE
,      COMPONENT_SEQUENCE_ID
,      ITEM_TYPE_CODE
,      ITEM_TYPE
,      ATO_FLAG
,      COMPONENT_CODE
,      COMPONENT_SORT_CODE
,      ORDERED_QUANTITY
,      CANCELLED_QUANTITY
,      RECEIVED_QUANTITY
,      ACCEPTED_QUANTITY
,      ACTUAL_RECEIPT_DATE
,      ACTUAL_ACCEPTED_DATE
,      UNIT_CODE
,      PRICE_LIST_ID
,      ROUNDING_FACTOR
,      PRICE_ADJUSTMENTS_TOTAL
,      PRICING_METHOD_CODE
,      LIST_PRICE
,      LIST_PERCENT
,      SELLING_PRICE
,      SELLING_PERCENT
,      WAREHOUSE_ID
,      WAREHOUSE_CODE
,      SHIPPED_QUANTITY
,      DATE_REQUESTED_CURRENT
,      SHIP_TO_SITE_USE_ID
,      TERMS_ID
,      INVOICED_QUANTITY
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_FLAG_DISPLAY
,      TAX_EXEMPT_NUMBER_DISPLAY
,      TAX_EXEMPT_REASON
,      TAX_EXEMPT_REASON_DISPLAY
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON_CODE
,      TAX_CODE_DISPLAY
,      TAX_CODE
,      TRANSACTION_REASON_CODE
,      RETURN_REASON_NAME
,      RETURN_REFERENCE_TYPE_CODE
,      RETURN_REFERENCE_TYPE_NAME
,      RETURN_REFERENCE_ID
,      CREDIT_INVOICE_LINE_ID
,      CREDIT_TO_INVOICE
,      INSPECTION_REQUIRED_FLAG
,      RETURN_FOR_REPAIR_FLAG
,      REFERENCE_NUMBER
,      REFERENCE_HEADER_ID
,      REFERENCE_LINE_NUMBER
,      REFERENCE_SHIPMENT_NUMBER
,      REFERENCE_OPTION_NUMBER
,      REFERENCE_CREATION_DATE
,      ORIGINAL_ORDERED_QUANTITY
,      PRICING_CONTEXT
,      PRICING_ATTRIBUTE1
,      PRICING_ATTRIBUTE2
,      PRICING_ATTRIBUTE3
,      PRICING_ATTRIBUTE4
,      PRICING_ATTRIBUTE5
,      PRICING_ATTRIBUTE6
,      PRICING_ATTRIBUTE7
,      PRICING_ATTRIBUTE8
,      PRICING_ATTRIBUTE9
,      PRICING_ATTRIBUTE10
,      PRICING_ATTRIBUTE11
,      PRICING_ATTRIBUTE12
,      PRICING_ATTRIBUTE13
,      PRICING_ATTRIBUTE14
,      PRICING_ATTRIBUTE15
,      S1
,      S1_DATE
,      S2
,      S2_DATE
,      S3
,      S3_DATE
,      S4
,      S4_DATE
,      S5
,      S5_DATE
,      S6
,      S6_DATE
,      S7
,      S7_DATE
,      S8
,      S8_DATE
,      S9
,      S9_DATE
,      S10
,      S10_DATE
,      S11
,      S11_DATE
,      S12
,      S12_DATE
,      S13
,      S13_DATE
,      S14
,      S14_DATE
,      S15
,      S15_DATE
,      S16
,      S16_DATE
,      S17
,      S17_DATE
,      S18
,      S18_DATE
,      S19
,      S19_DATE
,      S20
,      S20_DATE
,      S21
,      S21_DATE
,      S22
,      S22_DATE
,      S23
,      S23_DATE
,      S24
,      S24_DATE
,      S25
,      S25_DATE
,      S26
,      S26_DATE
,      S27
,      S27_DATE
,      S28
,      S28_DATE
,      S29
,      S29_DATE
,      S30
,      S30_DATE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      NUMBER_SVRID
,      ITEM_SVRID
,      ORDERED_QUANTITY_SVRID
,      UNIT_SVRID
,      PRICING_ATTRIBUTES_SVRID
,      LIST_PRICE_SVRID
,      SELLING_PRICE_SVRID
,      LIST_PERCENT_SVRID
,      SELLING_PERCENT_SVRID
,      WAREHOUSE_SVRID
,      DEMAND_CLASS_SVRID
,      SHIP_SET_NUMBER_SVRID
,      REQUEST_DATE_SVRID
,      PROMISE_DATE_SVRID
,      SCHEDULE_DATE_SVRID
,      SHIP_TO_SVRID
,      SHIP_TO_CONTACT_SVRID
,      SHIPMENT_PRIORITY_SVRID
,      FREIGHT_CARRIER_SVRID
,      AGREEMENT_SVRID
,      COMMITMENT_SVRID
,      PAYMENT_TERMS_SVRID
,      INVOICING_RULE_SVRID
,      ACCOUNTING_RULE_SVRID
,      TAX_EXEMPT_NUMBER_SVRID
,      TAX_EXEMPT_REASON_SVRID
,      TRANSACTION_TYPE_SVRID
,      TRANSACTION_REASON_SVRID
,      TRANSACTION_COMMENTS_SVRID
,      RETURN_REFERENCE_TYPE_SVRID
,      RETURN_REFERENCE_SVRID
,      CREDIT_INVOICE_LINE_SVRID
,      INSPECTION_REQUIRED_SVRID
,      CUSTOMER_PRODUCT_SVRID
,      CUSTOMER_PRODUCT_SERVICE_SVRID
,      SERVICE_DURATION_SVRID
,      SERVICE_START_DATE_SVRID
,      SERVICE_END_DATE_SVRID
,      SERVICE_PER_CONV_RATE_SVRID
,      SERVICE_COTERMINATE_SVRID
,      DF_SVRID
,      TAX_CODE_SVRID
,      LATEST_ACCEPTABLE_DATE_SVRID
,      ATO_LINE_ID
,      ACCOUNTING_RULE_ID
,      AGREEMENT_ID
,      COMMITMENT_ID
,      CONFIGURATION_EDITED_FLAG
,      CUSTOMER_PRODUCT_ID
,      CP_SERVICE_ID
,      DEMAND_CLASS_CODE
,      SHIP_METHOD_CODE
,      INVOICE_COUNT
,      QUANTITY_TO_INVOICE
,      INVOICING_RULE_ID
,      LATEST_ACCEPTABLE_DATE
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      PERCENT_BASE_PRICE
,      PRICING_DATE
,      REVENUE_AMOUNT
,      SCHEDULE_DATE
,      SERVICE_COTERMINATE_FLAG
,      SERVICE_DURATION
,      SERVICE_END_DATE
,      SERVICE_MASS_TXN_TEMP_ID
,      SERVICE_PARENT_LINE_ID
,      SERVICE_PERIOD_CONVERSION_RATE
,      SERVICE_START_DATE
,      SERVICED_QUANTITY
,      SHIP_MODEL_COMPLETE_FLAG
,      SHIP_SET_NUMBER
,      SHIP_TO_CONTACT_ID
,      SOURCE_LINE_ID
,      STANDARD_COMPONENT_FREEZE_DATE
,      TRANSACTION_COMMENTS
,      TRANSACTION_TYPE_CODE
,      PROMISE_DATE
,      SHIPMENT_PRIORITY_CODE
,      SHIPMENT_SCHEDULE_LINE_ID
,      SOURCE_TYPE_CODE
,      SOURCE_TYPE
,      SOURCE_TYPE_CODE_SVRID
,      PLANNING_PRIORITY
,      PLANNING_PRIORITY_SVRID
FROM APPS.SO_LINES_RMA_V;

Dependencies

[top of page]

APPS.SO_LINES_RMA_V references the following:

APPS: AR_LOOKUPS; AR_VAT_TAX; FND_GLOBAL - show dependent code; FND_PROFILE - show dependent code; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_VL; OE_QUERY - show dependent code; QP_PRICE_LIST_PVT - show dependent code; RA_CUSTOMER_TRX; RA_CUSTOMER_TRX_LINES; SO_HEADERS; SO_LINES; SO_LOOKUPS; SO_PRICE_LISTS

APPS.SO_LINES_RMA_V is not referenced by any database object