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

VIEW: APPS.DDR_B_RTL_SL_RTN_ITM_DAY_TGT_V

Object Details
Object Name: DDR_B_RTL_SL_RTN_ITM_DAY_TGT_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RTL_ORG_CD VARCHAR2 (30) Yes Retail Organization Code
ORG_BSNS_UNIT_ID NUMBER
Yes Organization Business Unit Id
DAY_CD VARCHAR2 (30) Yes Day Code
RTL_SKU_ITEM_ID NUMBER
Yes Retail SKU Item Id
PRMTN_FLAG VARCHAR2 (1)
Promotion Flag
MFG_SKU_ITEM_ID NUMBER

Manufacturer SKU Item Id
MFG_PRMTN_ID NUMBER

Manufacturer Promotion Id
SLS_TYP_CD VARCHAR2 (30)
Sales Type
ROW_IDENT ROWID (10)
Rowid
Query Text

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


SELECT RTL_ORG_CD
,      ORG_BSNS_UNIT_ID
,      DAY_CD
,      RTL_SKU_ITEM_ID
,      PRMTN_FLAG
,      MFG_SKU_ITEM_ID
,      MFG_PRMTN_ID
,      SLS_TYP_CD
,      ROW_IDENT
FROM APPS.DDR_B_RTL_SL_RTN_ITM_DAY_TGT_V;

Dependencies

[top of page]

APPS.DDR_B_RTL_SL_RTN_ITM_DAY_TGT_V references the following:

SchemaAPPS
SynonymDDR_B_RTL_SL_RTN_ITM_DAY

APPS.DDR_B_RTL_SL_RTN_ITM_DAY_TGT_V is not referenced by any database object