[Home] [Help]
[Dependency Information]
VIEW: APPS.ZX_FC_PRODUCT_FISCAL_V
Object Details
Object Name: | ZX_FC_PRODUCT_FISCAL_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FND.ZX_FC_PRODUCT_FISCAL_V
|
---|
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
CATEGORY_ID |
NUMBER |
|
Yes |
|
STRUCTURE_ID |
NUMBER |
|
Yes |
|
CATEGORY_SET_ID |
NUMBER |
|
Yes |
|
CLASSIFICATION_NAME |
VARCHAR2 |
(240) |
|
|
CLASSIFICATION_CODE |
VARCHAR2 |
(163) |
|
|
STRUCTURE_NAME |
VARCHAR2 |
(30) |
Yes |
|
STRUCTURE_CODE |
VARCHAR2 |
(30) |
Yes |
|
COUNTRY_CODE |
VARCHAR2 |
(2) |
Yes |
|
EFFECTIVE_TO |
DATE |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT CATEGORY_ID
, STRUCTURE_ID
, CATEGORY_SET_ID
, CLASSIFICATION_NAME
, CLASSIFICATION_CODE
, STRUCTURE_NAME
, STRUCTURE_CODE
, COUNTRY_CODE
, EFFECTIVE_TO
FROM APPS.ZX_FC_PRODUCT_FISCAL_V;
Dependencies
[top of page]
APPS.ZX_FC_PRODUCT_FISCAL_V references the following:
-
APPS
-
FND_ID_FLEX_STRUCTURES_VL
-
MTL_CATEGORIES_B_KFV
-
MTL_CATEGORIES_TL
-
MTL_CATEGORY_SETS_B
-
ZX_FC_COUNTRY_DEFAULTS
APPS.ZX_FC_PRODUCT_FISCAL_V is referenced by following:
-
APPS
-
AP_ETAX_UTILITY_PKG
- show dependent code
-
JL_ZZ_RECEIV_INTERFACE
- show dependent code
-
JL_ZZ_TAX_VALIDATE_PKG
- show dependent code
-
ZX_DEFAULT_AUTOMATION_PKG
- show dependent code
-
ZX_VALIDATE_API_PKG
- show dependent code