Skip to content

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

VIEW: APPS.AR_TO_SOP_DRILLDOWN_VIEW

Object Details
Object Name: AR_TO_SOP_DRILLDOWN_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMF.AR_TO_SOP_DRILLDOWN_VIEW
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


AR to SOP drilldown view


[View Source]

Columns
Name Datatype Length Mandatory Comments
OH_ORDER_ID NUMBER (10) Yes Oh Order Id
OH_ORGN_CODE_ORDER_NO VARCHAR2 (36)
oh orgn code order number
OH_ORDER_DATE DATE
Yes sales order date
OH_CUSTPO_NO VARCHAR2 (40)
sales order customerpo number
OH_ORGN_CODE VARCHAR2 (4) Yes orgn code
BL_BOL_ID NUMBER (10) Yes bill identifier
BL_ORGN_CODE_BOL_NO VARCHAR2 (36)
orgn code bill number
BL_WAYBILL_NO VARCHAR2 (32)
waybill number
BL_TRAILER_NO VARCHAR2 (40)
trailer Number
BL_DEBARKATION_PORT VARCHAR2 (8)
Debaraktion port
BL_EMBARKATION_PORT VARCHAR2 (8)
Embarkation Port
BL_SHIPPER_CODE VARCHAR2 (4) Yes Shipper code
OD_ACTAUL_SHIP_DATE DATE

Actual Ship Date
BS_NAME VARCHAR2 (50) Yes Batch sources name
TT_NAME VARCHAR2 (20)
Customer transaction source name
CT_TRX_NUMBER VARCHAR2 (20) Yes customer transaction number
Query Text

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


SELECT OH_ORDER_ID
,      OH_ORGN_CODE_ORDER_NO
,      OH_ORDER_DATE
,      OH_CUSTPO_NO
,      OH_ORGN_CODE
,      BL_BOL_ID
,      BL_ORGN_CODE_BOL_NO
,      BL_WAYBILL_NO
,      BL_TRAILER_NO
,      BL_DEBARKATION_PORT
,      BL_EMBARKATION_PORT
,      BL_SHIPPER_CODE
,      OD_ACTAUL_SHIP_DATE
,      BS_NAME
,      TT_NAME
,      CT_TRX_NUMBER
FROM APPS.AR_TO_SOP_DRILLDOWN_VIEW;

Dependencies

[top of page]

APPS.AR_TO_SOP_DRILLDOWN_VIEW references the following:

SchemaAPPS
SynonymOP_BILL_LAD
SynonymOP_ORDR_DTL
SynonymOP_ORDR_HDR
SynonymRA_BATCH_SOURCES
SynonymRA_CUSTOMER_TRX
SynonymRA_CUSTOMER_TRX_LINES
SynonymRA_CUST_TRX_TYPES

APPS.AR_TO_SOP_DRILLDOWN_VIEW is not referenced by any database object