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.

[Home] [Help]

Table: PA_DRAFT_INVOICE_ITEMS

Product:	PA - Projects
Description:	Draft invoice lines
Implementation/DBA Data:	PA.PA_DRAFT_INVOICE_ITEMS

Primary Key: PA_DRAFT_INVOICE_ITEMS_PK

PROJECT_ID
DRAFT_INVOICE_NUM
LINE_NUM

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_DRAFT_INVOICE_ITEMS	FND_LOOKUP_VALUES	PA_DRAFT_INVOICE_ITEMS.FLE_LOOKUP_TYPE PA_DRAFT_INVOICE_ITEMS.FLE_LANGUAGE PA_DRAFT_INVOICE_ITEMS.FLE_LOOKUP_CODE PA_DRAFT_INVOICE_ITEMS.FLE_SECURITY_GROUP_ID PA_DRAFT_INVOICE_ITEMS.FLE_VIEW_APPLICATION_ID
PA_DRAFT_INVOICE_ITEMS	FND_LOOKUP_VALUES	PA_DRAFT_INVOICE_ITEMS.FLE_LOOKUP_TYPE2 PA_DRAFT_INVOICE_ITEMS.FLE_LANGUAGE2 PA_DRAFT_INVOICE_ITEMS.FLE_LOOKUP_CODE2 PA_DRAFT_INVOICE_ITEMS.FLE_SECURITY_GROUP_ID2 PA_DRAFT_INVOICE_ITEMS.FLE_VIEW_APPLICATION_ID2
PA_DRAFT_INVOICE_ITEMS	FND_LOOKUP_VALUES	PA_DRAFT_INVOICE_ITEMS.FLE_LOOKUP_TYPE3 PA_DRAFT_INVOICE_ITEMS.FLE_LANGUAGE3 PA_DRAFT_INVOICE_ITEMS.FLE_LOOKUP_CODE3 PA_DRAFT_INVOICE_ITEMS.FLE_SECURITY_GROUP_ID3 PA_DRAFT_INVOICE_ITEMS.FLE_VIEW_APPLICATION_ID3
PA_DRAFT_INVOICE_ITEMS	PA_DRAFT_INVOICES_ALL	PA_DRAFT_INVOICE_ITEMS.PROJECT_ID PA_DRAFT_INVOICE_ITEMS.DRAFT_INVOICE_NUM
PA_DRAFT_INVOICE_ITEMS	GL_CODE_COMBINATIONS	PA_DRAFT_INVOICE_ITEMS.CC_REV_CODE_COMBINATION_ID
PA_DRAFT_INVOICE_ITEMS	AR_VAT_TAX_ALL_B	PA_DRAFT_INVOICE_ITEMS.OUTPUT_VAT_TAX_ID
PA_DRAFT_INVOICE_ITEMS	HZ_CUST_ACCT_SITES_ALL	PA_DRAFT_INVOICE_ITEMS.SHIP_TO_ADDRESS_ID
PA_DRAFT_INVOICE_ITEMS	PA_DRAFT_INVOICE_ITEMS	PA_DRAFT_INVOICE_ITEMS.PROJECT_ID PA_DRAFT_INVOICE_ITEMS.RETN_DRAFT_INVOICE_NUM PA_DRAFT_INVOICE_ITEMS.RETN_DRAFT_INVOICE_LINE_NUM
PA_DRAFT_INVOICE_ITEMS	PA_BILLING_CYCLES	PA_DRAFT_INVOICE_ITEMS.RETN_BILLING_CYCLE_ID
PA_DRAFT_INVOICE_ITEMS	PA_TASKS	PA_DRAFT_INVOICE_ITEMS.TASK_ID
PA_DRAFT_INVOICE_ITEMS	RA_ADDRESSES_ALL	PA_DRAFT_INVOICE_ITEMS.SHIP_TO_ADDRESS_ID
PA_DRAFT_INVOICE_ITEMS	AR_VAT_TAX_ALL_B	PA_DRAFT_INVOICE_ITEMS.OUTPUT_VAT_TAX_ID
PA_DRAFT_INVOICE_ITEMS	PA_PROJECTS_ALL	PA_DRAFT_INVOICE_ITEMS.CC_PROJECT_ID
PA_DRAFT_INVOICE_ITEMS	PA_TASKS	PA_DRAFT_INVOICE_ITEMS.CC_TAX_TASK_ID
PA_DRAFT_INVOICE_ITEMS	PA_DRAFT_INVOICE_ITEMS	PA_DRAFT_INVOICE_ITEMS.PROJECT_ID PA_DRAFT_INVOICE_ITEMS.DRAFT_INVOICE_NUM PA_DRAFT_INVOICE_ITEMS.DRAFT_INV_LINE_NUM_CREDITED
PA_CUST_EVENT_RDL_ALL	PA_DRAFT_INVOICE_ITEMS	PA_CUST_EVENT_RDL_ALL.PROJECT_ID PA_CUST_EVENT_RDL_ALL.RETN_DRAFT_INVOICE_NUM PA_CUST_EVENT_RDL_ALL.RETN_DRAFT_INVOICE_LINE_NUM
PA_CUST_EVENT_RDL_ALL	PA_DRAFT_INVOICE_ITEMS	PA_CUST_EVENT_RDL_ALL.PROJECT_ID PA_CUST_EVENT_RDL_ALL.DRAFT_INVOICE_NUM PA_CUST_EVENT_RDL_ALL.DRAFT_INVOICE_ITEM_LINE_NUM
PA_CUST_REV_DIST_LINES_ALL	PA_DRAFT_INVOICE_ITEMS	PA_CUST_REV_DIST_LINES_ALL.PROJECT_ID PA_CUST_REV_DIST_LINES_ALL.RETN_DRAFT_INVOICE_NUM PA_CUST_REV_DIST_LINES_ALL.RETN_DRAFT_INVOICE_LINE_NUM
PA_CUST_REV_DIST_LINES_ALL	PA_DRAFT_INVOICE_ITEMS	PA_CUST_REV_DIST_LINES_ALL.PROJECT_ID PA_CUST_REV_DIST_LINES_ALL.DRAFT_INVOICE_NUM PA_CUST_REV_DIST_LINES_ALL.DRAFT_INVOICE_ITEM_LINE_NUM
PA_DRAFT_INVOICE_DETAILS_ALL	PA_DRAFT_INVOICE_ITEMS	PA_DRAFT_INVOICE_DETAILS_ALL.PROJECT_ID PA_DRAFT_INVOICE_DETAILS_ALL.DRAFT_INVOICE_NUM PA_DRAFT_INVOICE_DETAILS_ALL.DRAFT_INVOICE_LINE_NUM
PA_DRAFT_INVOICE_DETAILS_ALL	PA_DRAFT_INVOICE_ITEMS	PA_DRAFT_INVOICE_DETAILS_ALL.PROJECT_ID PA_DRAFT_INVOICE_DETAILS_ALL.ORIG_DRAFT_INVOICE_NUM PA_DRAFT_INVOICE_DETAILS_ALL.ORIG_DRAFT_INVOICE_LINE_NUM
PA_DRAFT_INVOICE_ITEMS	PA_DRAFT_INVOICE_ITEMS	PA_DRAFT_INVOICE_ITEMS.PROJECT_ID PA_DRAFT_INVOICE_ITEMS.RETN_DRAFT_INVOICE_NUM PA_DRAFT_INVOICE_ITEMS.RETN_DRAFT_INVOICE_LINE_NUM
PA_DRAFT_INVOICE_ITEMS	PA_DRAFT_INVOICE_ITEMS	PA_DRAFT_INVOICE_ITEMS.PROJECT_ID PA_DRAFT_INVOICE_ITEMS.DRAFT_INVOICE_NUM PA_DRAFT_INVOICE_ITEMS.DRAFT_INV_LINE_NUM_CREDITED
PA_MC_CUST_EVENT_RDL_ALL	PA_DRAFT_INVOICE_ITEMS	PA_MC_CUST_EVENT_RDL_ALL.PROJECT_ID PA_MC_CUST_EVENT_RDL_ALL.DRAFT_INVOICE_NUM PA_MC_CUST_EVENT_RDL_ALL.DRAFT_INVOICE_ITEM_LINE_NUM
PA_MC_CUST_RDL_ALL	PA_DRAFT_INVOICE_ITEMS	PA_MC_CUST_RDL_ALL.PROJECT_ID PA_MC_CUST_RDL_ALL.DRAFT_INVOICE_ITEM_LINE_NUM PA_MC_CUST_RDL_ALL.LINE_NUM
PA_MC_DRAFT_INV_ITEMS	PA_DRAFT_INVOICE_ITEMS	PA_MC_DRAFT_INV_ITEMS.PROJECT_ID PA_MC_DRAFT_INV_ITEMS.DRAFT_INVOICE_NUM PA_MC_DRAFT_INV_ITEMS.LINE_NUM
PA_MC_RETN_INV_DETAILS	PA_DRAFT_INVOICE_ITEMS	PA_MC_RETN_INV_DETAILS.PROJECT_ID PA_MC_RETN_INV_DETAILS.DRAFT_INVOICE_NUM PA_MC_RETN_INV_DETAILS.LINE_NUM
PA_RETN_INVOICE_DETAILS	PA_DRAFT_INVOICE_ITEMS	PA_RETN_INVOICE_DETAILS.PROJECT_ID PA_RETN_INVOICE_DETAILS.DRAFT_INVOICE_NUM PA_RETN_INVOICE_DETAILS.LINE_NUM