[Home] [Help] [Dependency Information]
Object Name: | AR_TO_SOP_DRILLDOWN_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMF.AR_TO_SOP_DRILLDOWN_VIEW |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
AR to SOP drilldown view
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 |
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;
APPS.AR_TO_SOP_DRILLDOWN_VIEW is not referenced by any database object
|
|
|