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]

VIEW: FV.FV_IPAC_IMPORT_HISTORY#

Object Details

Object Name:	FV_IPAC_IMPORT_HISTORY#
Object Type:	VIEW
Owner:	FV
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
IPAC_IMPORT_ID	NUMBER		Yes
BATCH_NAME	VARCHAR2	(100)
TRANSACTION_ID	NUMBER	(16)
SUBMITTER_ALC	NUMBER	(8)
ORIGINATING_ALC	NUMBER	(8)
CUSTOMER_ALC	NUMBER	(8)
CONTACT_NAME	VARCHAR2	(60)
CONTACT_EMAIL_ADDRESS	VARCHAR2	(80)
CONTACT_PHONE_NUMBER	VARCHAR2	(17)
SUMMARY_AMOUNT	NUMBER	(14)
NUMER_OF_DETAIL_LINES	NUMBER	(6)
ACCOMPLISHED_DATE	DATE
ACCOUNTING_DATE	DATE
DETAIL_LINE_NUMBER	NUMBER	(6)
CONTRACT_NUMBER	VARCHAR2	(17)
PURCHASE_ORDER_NUMBER	VARCHAR2	(22)
CLIN	VARCHAR2	(6)
INVOICE_NUMBER	VARCHAR2	(22)
REQUISITION_NUMBER	VARCHAR2	(15)
QUANTITY	NUMBER	(12)
UNIT_OF_ISSUE	VARCHAR2	(2)
UNIT_PRICE	NUMBER	(19)
DETAIL_AMOUNT	NUMBER	(14)
PAY_FLAG	VARCHAR2	(1)
FY_OBLIGATION_ID	VARCHAR2	(1)
RECEIVER_TRES_ACCT_SYMBOL	VARCHAR2	(27)
RECEIVER_BETC	VARCHAR2	(8)
RECEIVER_DUNS	VARCHAR2	(9)
RECEIVER_DUNS_4	VARCHAR2	(4)
SENDER_TRES_ACCT_SYMBOL	VARCHAR2	(27)
SENDER_BETC	VARCHAR2	(8)
SENDER_DUNS	VARCHAR2	(9)
SENDER_DUNS_4	VARCHAR2	(4)
RECEIVER_DEPARTMENT_CODE	VARCHAR2	(2)
ACCOUNTING_CLASS_CODE	VARCHAR2	(16)
ACRN	VARCHAR2	(12)
JOB_PROJECT_NUMBER	VARCHAR2	(20)
JAS_NUMBER	VARCHAR2	(30)
FSN_AAA_ADSN	NUMBER	(8)
OBLIGATING_DOC_NUMBER	VARCHAR2	(17)
ACT_TRACE_NUMBER	VARCHAR2	(15)
DESCRIPTION	VARCHAR2	(320)
MISC_INFORMATION	VARCHAR2	(320)
TRANSACTION_TYPE	VARCHAR2	(1)
IPAC_DOC_REF_NUMBER	VARCHAR2	(8)
SENDER_DO_SYMBOL	VARCHAR2	(5)
DODACC	VARCHAR2	(15)
TRANSACTION_CONTACT	VARCHAR2	(60)
TRANSCATION_CONTACT_PHONE	VARCHAR2	(17)
VOUCHER_NUMBER	VARCHAR2	(8)
ORIGINAL_DO_SYMBOL	VARCHAR2	(5)
ORIG_ACCOMPLISHED_DATE	DATE
ORIG_ACCOUNTING_DATE	DATE
ORIG_DOC_REF_NUMBER	VARCHAR2	(8)
ORIG_TRANSACTION_TYPE	VARCHAR2	(1)
SENDER_SGL_COMMENT	VARCHAR2	(255)
RECEIVER_SGL_COMMENT	VARCHAR2	(255)
SGL_NUMBER1	NUMBER	(4)
SGL_SENDER_RECEIVER_FLAG1	VARCHAR2	(1)
SGL_FEDERAL_FLAG1	VARCHAR2	(1)
SGL_DEBIT_CREDIT_FLAG1	VARCHAR2	(1)
SGL_AMOUNT1	NUMBER	(14)
SGL_NUMBER2	NUMBER	(4)
SGL_SENDER_RECEIVER_FLAG2	VARCHAR2	(1)
SGL_FEDERAL_FLAG2	VARCHAR2	(1)
SGL_DEBIT_CREDIT_FLAG2	VARCHAR2	(1)
SGL_AMOUNT2	NUMBER	(14)
SGL_NUMBER3	NUMBER	(4)
SGL_SENDER_RECEIVER_FLAG3	VARCHAR2	(1)
SGL_FEDERAL_FLAG3	VARCHAR2	(1)
SGL_DEBIT_CREDIT_FLAG3	VARCHAR2	(1)
SGL_AMOUNT3	NUMBER	(14)
SGL_NUMBER4	NUMBER	(4)
SGL_SENDER_RECEIVER_FLAG4	VARCHAR2	(1)
SGL_FEDERAL_FLAG4	VARCHAR2	(1)
SGL_DEBIT_CREDIT_FLAG4	VARCHAR2	(1)
SGL_AMOUNT4	NUMBER	(14)
SGL_NUMBER5	NUMBER	(4)
SGL_SENDER_RECEIVER_FLAG5	VARCHAR2	(1)
SGL_FEDERAL_FLAG5	VARCHAR2	(1)
SGL_DEBIT_CREDIT_FLAG5	VARCHAR2	(1)
SGL_AMOUNT5	NUMBER	(14)
SGL_NUMBER6	NUMBER	(4)
SGL_SENDER_RECEIVER_FLAG6	VARCHAR2	(1)
SGL_FEDERAL_FLAG6	VARCHAR2	(1)
SGL_DEBIT_CREDIT_FLAG6	VARCHAR2	(1)
SGL_AMOUNT6	NUMBER	(14)
SGL_NUMBER7	NUMBER	(4)
SGL_SENDER_RECEIVER_FLAG7	VARCHAR2	(1)
SGL_FEDERAL_FLAG7	VARCHAR2	(1)
SGL_DEBIT_CREDIT_FLAG7	VARCHAR2	(1)
SGL_AMOUNT7	NUMBER	(14)
SGL_NUMBER8	NUMBER	(4)
SGL_SENDER_RECEIVER_FLAG8	VARCHAR2	(1)
SGL_FEDERAL_FLAG8	VARCHAR2	(1)
SGL_DEBIT_CREDIT_FLAG8	VARCHAR2	(1)
SGL_AMOUNT8	NUMBER	(14)
SGL_NUMBER9	NUMBER	(4)
SGL_SENDER_RECEIVER_FLAG9	VARCHAR2	(1)
SGL_FEDERAL_FLAG9	VARCHAR2	(1)
SGL_DEBIT_CREDIT_FLAG9	VARCHAR2	(1)
SGL_AMOUNT9	NUMBER	(14)
SGL_NUMBER10	NUMBER	(4)
SGL_SENDER_RECEIVER_FLAG10	VARCHAR2	(1)
SGL_FEDERAL_FLAG10	VARCHAR2	(1)
SGL_DEBIT_CREDIT_FLAG10	VARCHAR2	(1)
SGL_AMOUNT10	NUMBER	(14)
SGL_NUMBER11	NUMBER	(4)
SGL_SENDER_RECEIVER_FLAG11	VARCHAR2	(1)
SGL_FEDERAL_FLAG11	VARCHAR2	(1)
SGL_DEBIT_CREDIT_FLAG11	VARCHAR2	(1)
SGL_AMOUNT11	NUMBER	(14)
SGL_NUMBER12	NUMBER
SGL_SENDER_RECEIVER_FLAG12	VARCHAR2	(1)
SGL_FEDERAL_FLAG12	VARCHAR2	(1)
SGL_DEBIT_CREDIT_FLAG12	VARCHAR2	(1)
SGL_AMOUNT12	NUMBER	(14)
SGL_NUMBER13	NUMBER	(4)
SGL_SENDER_RECEIVER_FLAG13	VARCHAR2	(1)
SGL_FEDERAL_FLAG13	VARCHAR2	(1)
SGL_DEBIT_CREDIT_FLAG13	VARCHAR2	(1)
SGL_AMOUNT13	NUMBER	(4)
SGL_NUMBER14	NUMBER	(4)
SGL_SENDER_RECEIVER_FLAG14	VARCHAR2	(1)
SGL_FEDERAL_FLAG14	VARCHAR2	(1)
SGL_DEBIT_CREDIT_FLAG14	VARCHAR2	(1)
SGL_AMOUNT14	NUMBER	(14)
SGL_NUMBER15	NUMBER	(4)
SGL_SENDER_RECEIVER_FLAG15	VARCHAR2	(1)
SGL_FEDERAL_FLAG15	VARCHAR2	(1)
SGL_DEBIT_CREDIT_FLAG15	VARCHAR2	(1)
SGL_AMOUNT15	NUMBER	(14)
SGL_NUMBER16	NUMBER	(4)
SGL_SENDER_RECEIVER_FLAG16	VARCHAR2	(1)
SGL_FEDERAL_FLAG16	VARCHAR2	(1)
SGL_DEBIT_CREDIT_FLAG16	VARCHAR2	(1)
SGL_AMOUNT16	NUMBER	(14)
RECORD_STATUS	VARCHAR2	(20)
ORG_ID	NUMBER
SET_OF_BOOKS_ID	NUMBER
INVOICE_ID	NUMBER
INVOICE_LINE_ID	NUMBER
ACTUAL_PO_NUMBER	VARCHAR2	(22)
ACTUAL_PO_LINE_NUMBER	NUMBER
VENDOR_ID	NUMBER
VENDOR_SITE_ID	NUMBER
CREATED_BY	NUMBER
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_DATE	DATE
REQUEST_ID	NUMBER
GROUP_ID	NUMBER
DATA_FILE	VARCHAR2	(256)
INT_INVOICE_ID	NUMBER
INT_INVOICE_LINE_ID	NUMBER

Query Text

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


SELECT IPAC_IMPORT_ID
,      BATCH_NAME
,      TRANSACTION_ID
,      SUBMITTER_ALC
,      ORIGINATING_ALC
,      CUSTOMER_ALC
,      CONTACT_NAME
,      CONTACT_EMAIL_ADDRESS
,      CONTACT_PHONE_NUMBER
,      SUMMARY_AMOUNT
,      NUMER_OF_DETAIL_LINES
,      ACCOMPLISHED_DATE
,      ACCOUNTING_DATE
,      DETAIL_LINE_NUMBER
,      CONTRACT_NUMBER
,      PURCHASE_ORDER_NUMBER
,      CLIN
,      INVOICE_NUMBER
,      REQUISITION_NUMBER
,      QUANTITY
,      UNIT_OF_ISSUE
,      UNIT_PRICE
,      DETAIL_AMOUNT
,      PAY_FLAG
,      FY_OBLIGATION_ID
,      RECEIVER_TRES_ACCT_SYMBOL
,      RECEIVER_BETC
,      RECEIVER_DUNS
,      RECEIVER_DUNS_4
,      SENDER_TRES_ACCT_SYMBOL
,      SENDER_BETC
,      SENDER_DUNS
,      SENDER_DUNS_4
,      RECEIVER_DEPARTMENT_CODE
,      ACCOUNTING_CLASS_CODE
,      ACRN
,      JOB_PROJECT_NUMBER
,      JAS_NUMBER
,      FSN_AAA_ADSN
,      OBLIGATING_DOC_NUMBER
,      ACT_TRACE_NUMBER
,      DESCRIPTION
,      MISC_INFORMATION
,      TRANSACTION_TYPE
,      IPAC_DOC_REF_NUMBER
,      SENDER_DO_SYMBOL
,      DODACC
,      TRANSACTION_CONTACT
,      TRANSCATION_CONTACT_PHONE
,      VOUCHER_NUMBER
,      ORIGINAL_DO_SYMBOL
,      ORIG_ACCOMPLISHED_DATE
,      ORIG_ACCOUNTING_DATE
,      ORIG_DOC_REF_NUMBER
,      ORIG_TRANSACTION_TYPE
,      SENDER_SGL_COMMENT
,      RECEIVER_SGL_COMMENT
,      SGL_NUMBER1
,      SGL_SENDER_RECEIVER_FLAG1
,      SGL_FEDERAL_FLAG1
,      SGL_DEBIT_CREDIT_FLAG1
,      SGL_AMOUNT1
,      SGL_NUMBER2
,      SGL_SENDER_RECEIVER_FLAG2
,      SGL_FEDERAL_FLAG2
,      SGL_DEBIT_CREDIT_FLAG2
,      SGL_AMOUNT2
,      SGL_NUMBER3
,      SGL_SENDER_RECEIVER_FLAG3
,      SGL_FEDERAL_FLAG3
,      SGL_DEBIT_CREDIT_FLAG3
,      SGL_AMOUNT3
,      SGL_NUMBER4
,      SGL_SENDER_RECEIVER_FLAG4
,      SGL_FEDERAL_FLAG4
,      SGL_DEBIT_CREDIT_FLAG4
,      SGL_AMOUNT4
,      SGL_NUMBER5
,      SGL_SENDER_RECEIVER_FLAG5
,      SGL_FEDERAL_FLAG5
,      SGL_DEBIT_CREDIT_FLAG5
,      SGL_AMOUNT5
,      SGL_NUMBER6
,      SGL_SENDER_RECEIVER_FLAG6
,      SGL_FEDERAL_FLAG6
,      SGL_DEBIT_CREDIT_FLAG6
,      SGL_AMOUNT6
,      SGL_NUMBER7
,      SGL_SENDER_RECEIVER_FLAG7
,      SGL_FEDERAL_FLAG7
,      SGL_DEBIT_CREDIT_FLAG7
,      SGL_AMOUNT7
,      SGL_NUMBER8
,      SGL_SENDER_RECEIVER_FLAG8
,      SGL_FEDERAL_FLAG8
,      SGL_DEBIT_CREDIT_FLAG8
,      SGL_AMOUNT8
,      SGL_NUMBER9
,      SGL_SENDER_RECEIVER_FLAG9
,      SGL_FEDERAL_FLAG9
,      SGL_DEBIT_CREDIT_FLAG9
,      SGL_AMOUNT9
,      SGL_NUMBER10
,      SGL_SENDER_RECEIVER_FLAG10
,      SGL_FEDERAL_FLAG10
,      SGL_DEBIT_CREDIT_FLAG10
,      SGL_AMOUNT10
,      SGL_NUMBER11
,      SGL_SENDER_RECEIVER_FLAG11
,      SGL_FEDERAL_FLAG11
,      SGL_DEBIT_CREDIT_FLAG11
,      SGL_AMOUNT11
,      SGL_NUMBER12
,      SGL_SENDER_RECEIVER_FLAG12
,      SGL_FEDERAL_FLAG12
,      SGL_DEBIT_CREDIT_FLAG12
,      SGL_AMOUNT12
,      SGL_NUMBER13
,      SGL_SENDER_RECEIVER_FLAG13
,      SGL_FEDERAL_FLAG13
,      SGL_DEBIT_CREDIT_FLAG13
,      SGL_AMOUNT13
,      SGL_NUMBER14
,      SGL_SENDER_RECEIVER_FLAG14
,      SGL_FEDERAL_FLAG14
,      SGL_DEBIT_CREDIT_FLAG14
,      SGL_AMOUNT14
,      SGL_NUMBER15
,      SGL_SENDER_RECEIVER_FLAG15
,      SGL_FEDERAL_FLAG15
,      SGL_DEBIT_CREDIT_FLAG15
,      SGL_AMOUNT15
,      SGL_NUMBER16
,      SGL_SENDER_RECEIVER_FLAG16
,      SGL_FEDERAL_FLAG16
,      SGL_DEBIT_CREDIT_FLAG16
,      SGL_AMOUNT16
,      RECORD_STATUS
,      ORG_ID
,      SET_OF_BOOKS_ID
,      INVOICE_ID
,      INVOICE_LINE_ID
,      ACTUAL_PO_NUMBER
,      ACTUAL_PO_LINE_NUMBER
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      REQUEST_ID
,      GROUP_ID
,      DATA_FILE
,      INT_INVOICE_ID
,      INT_INVOICE_LINE_ID
FROM FV.FV_IPAC_IMPORT_HISTORY#;

Dependencies

[top of page]

FV.FV_IPAC_IMPORT_HISTORY# references the following:

FV: FV_IPAC_IMPORT_HISTORY

FV.FV_IPAC_IMPORT_HISTORY# is referenced by following:

APPS: FV_IPAC_IMPORT_HISTORY