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

TABLE: IGI.IGI_CIS_MTH_RET_HDR_T_ALL

Object Details
Object Name: IGI_CIS_MTH_RET_HDR_T_ALL
Object Type: TABLE
Owner: IGI
Subobject Name:
Status: VALID


Interface header table in the monthly returns process.
The data is populated from the PO_VENDORS, AP_REPORTING_ENTITIES_ALL, AP_INVOICE_PAYMENTS_ALL, and AP_INVOICES_ALL tables during the outbound process.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER (15) Yes Header ID
REQUEST_ID NUMBER (15)
Request Id
ORG_ID NUMBER (15)
Organization ID
CIS_SENDER_ID VARCHAR2 (30)
CIS Sender ID
TAX_OFFICE_NUMBER NUMBER (15)
Tax office number
PAYE_REFERENCE VARCHAR2 (30)
PAYE reference of the reporting entity
REQUEST_STATUS_CODE VARCHAR2 (1)
Request Status
PROGRAM_APPLICATION_ID NUMBER (15)
Identifies the Oracle Applications' concurrent program
PROGRAM_ID NUMBER (15)
Identifies the concurrent program
PROGRAM_LOGIN_ID NUMBER (15)
Identifies the Oracle Applications concurrent program login ID
UNIQUE_TAX_REFERENCE_NUM NUMBER (15)
Unique tax reference number of the reporting entity
ACCOUNTS_OFFICE_REFERENCE VARCHAR2 (30)
Account office reference of the reporting entity.
PERIOD_NAME VARCHAR2 (15)
Period Name
PERIOD_ENDING_DATE DATE

The date period ends in CCYY-MM-DD format
NIL_RETURN_FLAG VARCHAR2 (1)
Nil Return indicator
EMPLOYMENT_STATUS_FLAG VARCHAR2 (1)
Employment status flag
SUBCONT_VERIFY_FLAG VARCHAR2 (1)
Subcontractor verification declaration
INFORMATION_CORRECT_FLAG VARCHAR2 (1)
Information Correct Declaration
INACTIVITY_INDICATOR VARCHAR2 (1)
Indicator that denotes inactivity
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
Query Text

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


SELECT HEADER_ID
,      REQUEST_ID
,      ORG_ID
,      CIS_SENDER_ID
,      TAX_OFFICE_NUMBER
,      PAYE_REFERENCE
,      REQUEST_STATUS_CODE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      UNIQUE_TAX_REFERENCE_NUM
,      ACCOUNTS_OFFICE_REFERENCE
,      PERIOD_NAME
,      PERIOD_ENDING_DATE
,      NIL_RETURN_FLAG
,      EMPLOYMENT_STATUS_FLAG
,      SUBCONT_VERIFY_FLAG
,      INFORMATION_CORRECT_FLAG
,      INACTIVITY_INDICATOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM IGI.IGI_CIS_MTH_RET_HDR_T_ALL;

Dependencies

[top of page]

IGI.IGI_CIS_MTH_RET_HDR_T_ALL does not reference any database object

IGI.IGI_CIS_MTH_RET_HDR_T_ALL is referenced by following:

SchemaIGI
ViewIGI_CIS_MTH_RET_HDR_T_ALL#