eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	APPS_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:

APPS: IGI_CIS_MTH_RET_HDR_T; IGI_CIS_MTH_RET_HDR_T_ALL