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


VIEW: APPS.IGI_RPI_STANDING_CHARGES_V

Object Details
Object Name: IGI_RPI_STANDING_CHARGES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGI.IGI_RPI_STANDING_CHARGES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
CHARGE_REFERENCE VARCHAR2 (50) Yes User-specified standing charge reference
STATUS VARCHAR2 (25) Yes Standing charge status lookup code
TERM_ID NUMBER

STANDING_CHARGE_DATE DATE

TRANSACTION_TYPE_NAME VARCHAR2 (20)
TERM_ID_NAME VARCHAR2 (15) Yes
CURRENCY_CODE VARCHAR2 (15) Yes
BATCH_SOURCE_NAME VARCHAR2 (50) Yes
SALESPERSON VARCHAR2 (240)
BILL_TO_CUSTOMER VARCHAR2 (50)
BILL_TO_NUMBER VARCHAR2 (30) Yes
BILL_ADDRESS1 VARCHAR2 (240) Yes
BILL_ADDRESS2 VARCHAR2 (240)
BILL_ADDRESS3 VARCHAR2 (240)
BILL_CONTACT VARCHAR2 (102)
SHIP_TO_CUSTOMER VARCHAR2 (50)
SHIP_TO_NUMBER VARCHAR2 (30)
SHIP_ADDRESS1 VARCHAR2 (240)
SHIP_ADDRESS2 VARCHAR2 (240)
SHIP_ADDRESS3 VARCHAR2 (240)
SHIP_CONTACT VARCHAR2 (102)
DESCRIPTION VARCHAR2 (240)
COMMENTS VARCHAR2 (240)
START_DATE DATE
Yes
END_DATE DATE

PERIOD_NAME VARCHAR2 (25) Yes
ADVANCE_ARREARS_IND VARCHAR2 (7)
NEXT_DUE_DATE DATE
Yes
REMINDER_DAYS NUMBER

REVIEW_DATE DATE

SUPPRESS_INV_PRINT VARCHAR2 (1)
RECEIPT_METHOD_NAME VARCHAR2 (30)
SET_OF_BOOKS_ID NUMBER (15) Yes
CUST_TRX_TYPE_ID NUMBER (15) Yes
GENERATE_SEQUENCE NUMBER (15)
STANDING_CHARGE_ID NUMBER (15) Yes
SALESREP_ID NUMBER (15) Yes
BATCH_SOURCE_ID NUMBER (15) Yes
BILL_TO_CUSTOMER_ID NUMBER (15) Yes
SHIP_TO_CUSTOMER_ID NUMBER (15)
BILL_TO_ADDRESS_ID NUMBER (15)
SHIP_TO_ADDRESS_ID NUMBER (15)
BILL_TO_CONTACT_ID NUMBER (15)
SHIP_TO_CONTACT_ID NUMBER (15)
RECEIPT_METHOD_ID NUMBER (15)
BANK_ACCOUNT_ID NUMBER (15)
BILL_TO_SITE_USE_ID NUMBER (15) Yes
SHIP_TO_SITE_USE_ID NUMBER (15)
CUSTOMER_ID NUMBER (15) Yes
PREVIOUS_DUE_DATE DATE

LAST_UPDATE_DATE DATE
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
ROW_ID ROWID (10)
COMPONENT VARCHAR2 (25) Yes
DEFAULT_INVOICING_RULE VARCHAR2 (30)
ORG_ID NUMBER

LEGAL_ENTITY_ID NUMBER

LEGAL_ENTITY_NAME VARCHAR2 (240) Yes
OPERATING_UNIT VARCHAR2 (240) Yes
PAYMENT_TRXN_EXTENSION_ID NUMBER

Payment Extension Identifier
Query Text

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


SELECT CHARGE_REFERENCE
,      STATUS
,      TERM_ID
,      STANDING_CHARGE_DATE
,      TRANSACTION_TYPE_NAME
,      TERM_ID_NAME
,      CURRENCY_CODE
,      BATCH_SOURCE_NAME
,      SALESPERSON
,      BILL_TO_CUSTOMER
,      BILL_TO_NUMBER
,      BILL_ADDRESS1
,      BILL_ADDRESS2
,      BILL_ADDRESS3
,      BILL_CONTACT
,      SHIP_TO_CUSTOMER
,      SHIP_TO_NUMBER
,      SHIP_ADDRESS1
,      SHIP_ADDRESS2
,      SHIP_ADDRESS3
,      SHIP_CONTACT
,      DESCRIPTION
,      COMMENTS
,      START_DATE
,      END_DATE
,      PERIOD_NAME
,      ADVANCE_ARREARS_IND
,      NEXT_DUE_DATE
,      REMINDER_DAYS
,      REVIEW_DATE
,      SUPPRESS_INV_PRINT
,      RECEIPT_METHOD_NAME
,      SET_OF_BOOKS_ID
,      CUST_TRX_TYPE_ID
,      GENERATE_SEQUENCE
,      STANDING_CHARGE_ID
,      SALESREP_ID
,      BATCH_SOURCE_ID
,      BILL_TO_CUSTOMER_ID
,      SHIP_TO_CUSTOMER_ID
,      BILL_TO_ADDRESS_ID
,      SHIP_TO_ADDRESS_ID
,      BILL_TO_CONTACT_ID
,      SHIP_TO_CONTACT_ID
,      RECEIPT_METHOD_ID
,      BANK_ACCOUNT_ID
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_SITE_USE_ID
,      CUSTOMER_ID
,      PREVIOUS_DUE_DATE
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ROW_ID
,      COMPONENT
,      DEFAULT_INVOICING_RULE
,      ORG_ID
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
,      OPERATING_UNIT
,      PAYMENT_TRXN_EXTENSION_ID
FROM APPS.IGI_RPI_STANDING_CHARGES_V;

Dependencies

[top of page]

APPS.IGI_RPI_STANDING_CHARGES_V references the following:

SchemaAPPS
SynonymAR_RECEIPT_METHODS
ViewHR_OPERATING_UNITS
SynonymHZ_CUST_ACCOUNTS_ALL
SynonymHZ_CUST_ACCOUNT_ROLES
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_LOCATIONS
SynonymHZ_ORG_CONTACTS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymHZ_RELATIONSHIPS
SynonymIGI_RPI_COMPONENT_PERIODS
SynonymIGI_RPI_STANDING_CHARGES
SynonymRA_BATCH_SOURCES_ALL
SynonymRA_CUST_TRX_TYPES_ALL
SynonymRA_SALESREPS_ALL
ViewRA_TERMS_VL
ViewXLE_LE_OU_LEDGER_V

APPS.IGI_RPI_STANDING_CHARGES_V is not referenced by any database object