[Home] [Help] [Dependency Information]
Object Name: | OKL_KHR_TNC_BILL_SETUP_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_KHR_TNC_BILL_SETUP_UV |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHR_ID | NUMBER | Yes | Unique identifier of Contract. Also primary key column of the table. | |
BILL_TO_SITE_USE_ID | NUMBER | (15) | Stores account site use identifier. This column is used to identify the billing address of the customer account. References HZ_CUST_ACCT_SITES_ALL.SITE_USE_ID where SITE_USE_CODE='BILL_TO'. | |
BILL_TO_SITE_NAME | VARCHAR2 | (40) | Site use identifier | |
RGP_ID | VARCHAR2 | (0) | Placeholder for Rule Group Identifier | |
RGP_LABILL_LAPMTH_ID | VARCHAR2 | (0) | Placeholder for Rule Group Identifier | |
RGP_LABILL_LABACC_ID | VARCHAR2 | (0) | Placeholder for Rule Group Identifier | |
RGP_LABILL_LAINVD_ID | VARCHAR2 | (0) | Placeholder for Rule Group Identifier | |
RGP_LABILL_LAINPR_ID | VARCHAR2 | (0) | Placeholder for Rule Group Identifier | |
RUL_LAPMTH_ID | VARCHAR2 | (0) | Placeholder for Rule Identifier for Rule LAPMTH | |
RUL_LABACC_ID | VARCHAR2 | (0) | Placeholder for Rule Identifier for Rule LABACC | |
RUL_LAINVD_ID | VARCHAR2 | (0) | Placeholder for Rule Identifier for Rule LAINVD | |
RUL_LAINPR_ID | VARCHAR2 | (0) | Placeholder for Rule Identifier for Rule LAINPR | |
RUL_LAPMTH_OBJECT1_ID1 | VARCHAR2 | (0) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view | |
RUL_LAPMTH_OBJECT1_ID2 | VARCHAR2 | (0) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view | |
RUL_LAPMTH_NAME | VARCHAR2 | (0) | Placeholder for Payment Method Name | |
RUL_LABACC_OBJECT1_ID1 | VARCHAR2 | (0) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view | |
RUL_LABACC_OBJECT1_ID2 | VARCHAR2 | (0) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view | |
RUL_LABACC_NAME | VARCHAR2 | (0) | Placeholder for Bank Account Name | |
RUL_LABACC_BANK_NAME | VARCHAR2 | (0) | Placeholder for Bank Name | |
LAINVD_RULE_INFORMATION1 | VARCHAR2 | (0) | Placeholder for RULE_INFORMATION1 for Rule LAINVD | |
LAINVD_INVOICE_FORMAT_MEANING | VARCHAR2 | (0) | Placeholder for Invoice Format Name | |
LAINVD_RULE_INFORMATION3 | VARCHAR2 | (0) | Placeholder for RULE_INFORMATION3 for Rule LAINVD | |
LAINVD_RULE_INFORMATION4 | VARCHAR2 | (0) | Placeholder for RULE_INFORMATION4 for Rule LAINVD | |
RUL_LAINVD_OBJECT1_ID1 | VARCHAR2 | (0) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view | |
RUL_LAINVD_OBJECT1_ID2 | VARCHAR2 | (0) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view | |
RUL_LAINVD_NAME | VARCHAR2 | (0) | Placeholder for Cash Application Rule Name | |
LAINPR_RULE_INFORMATION1 | VARCHAR2 | (0) | Placeholder for RULE_INFORMATION1 for Rule LAINPR | |
LAINPR_RULE_INFORMATION2 | VARCHAR2 | (0) | Placeholder for RULE_INFORMATION2 for Rule LAINPR | |
CUST_ACCT_ID | NUMBER | (15) | Customer Acccount Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT CHR_ID
, BILL_TO_SITE_USE_ID
, BILL_TO_SITE_NAME
, RGP_ID
, RGP_LABILL_LAPMTH_ID
, RGP_LABILL_LABACC_ID
, RGP_LABILL_LAINVD_ID
, RGP_LABILL_LAINPR_ID
, RUL_LAPMTH_ID
, RUL_LABACC_ID
, RUL_LAINVD_ID
, RUL_LAINPR_ID
, RUL_LAPMTH_OBJECT1_ID1
, RUL_LAPMTH_OBJECT1_ID2
, RUL_LAPMTH_NAME
, RUL_LABACC_OBJECT1_ID1
, RUL_LABACC_OBJECT1_ID2
, RUL_LABACC_NAME
, RUL_LABACC_BANK_NAME
, LAINVD_RULE_INFORMATION1
, LAINVD_INVOICE_FORMAT_MEANING
, LAINVD_RULE_INFORMATION3
, LAINVD_RULE_INFORMATION4
, RUL_LAINVD_OBJECT1_ID1
, RUL_LAINVD_OBJECT1_ID2
, RUL_LAINVD_NAME
, LAINPR_RULE_INFORMATION1
, LAINPR_RULE_INFORMATION2
, CUST_ACCT_ID
FROM APPS.OKL_KHR_TNC_BILL_SETUP_UV;
APPS.OKL_KHR_TNC_BILL_SETUP_UV is not referenced by any database object
|
|
|