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: ViewOE.SO_LINES_RMA_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
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:

SchemaAPPS
ViewAR_LOOKUPS
SynonymAR_VAT_TAX
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
SynonymMTL_PARAMETERS
ViewMTL_SYSTEM_ITEMS_VL
PL/SQL PackageOE_QUERY - show dependent code
PL/SQL PackageQP_PRICE_LIST_PVT - show dependent code
SynonymRA_CUSTOMER_TRX
SynonymRA_CUSTOMER_TRX_LINES
ViewSO_HEADERS
ViewSO_LINES
SynonymSO_LOOKUPS
SynonymSO_PRICE_LISTS

APPS.SO_LINES_RMA_V is not referenced by any database object