FND Design Data [Home] [Help]

Table: PA_DRAFT_INVOICE_ITEMS

Product: PA - Projects
Description: Draft invoice lines
Implementation/DBA Data: TablePA.PA_DRAFT_INVOICE_ITEMS
Primary Key: PA_DRAFT_INVOICE_ITEMS_PK
  1. ColumnPROJECT_ID
  2. ColumnDRAFT_INVOICE_NUM
  3. ColumnLINE_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
PA_DRAFT_INVOICE_ITEMS FK Joins to TableFND_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 FK Joins to TableFND_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 FK Joins to TableFND_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 FK Joins to TablePA_DRAFT_INVOICES_ALL PA_DRAFT_INVOICE_ITEMS.PROJECT_ID
PA_DRAFT_INVOICE_ITEMS.DRAFT_INVOICE_NUM
PA_DRAFT_INVOICE_ITEMS FK Joins to TableGL_CODE_COMBINATIONS PA_DRAFT_INVOICE_ITEMS.CC_REV_CODE_COMBINATION_ID
PA_DRAFT_INVOICE_ITEMS FK Joins to TableAR_VAT_TAX_ALL_B PA_DRAFT_INVOICE_ITEMS.OUTPUT_VAT_TAX_ID
PA_DRAFT_INVOICE_ITEMS FK Joins to TableHZ_CUST_ACCT_SITES_ALL PA_DRAFT_INVOICE_ITEMS.SHIP_TO_ADDRESS_ID
PA_DRAFT_INVOICE_ITEMS FK Joins to TablePA_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 FK Joins to TablePA_BILLING_CYCLES PA_DRAFT_INVOICE_ITEMS.RETN_BILLING_CYCLE_ID
PA_DRAFT_INVOICE_ITEMS FK Joins to TablePA_TASKS PA_DRAFT_INVOICE_ITEMS.TASK_ID
PA_DRAFT_INVOICE_ITEMS FK Joins to TableRA_ADDRESSES_ALL PA_DRAFT_INVOICE_ITEMS.SHIP_TO_ADDRESS_ID
PA_DRAFT_INVOICE_ITEMS FK Joins to TableAR_VAT_TAX_ALL_B PA_DRAFT_INVOICE_ITEMS.OUTPUT_VAT_TAX_ID
PA_DRAFT_INVOICE_ITEMS FK Joins to TablePA_PROJECTS_ALL PA_DRAFT_INVOICE_ITEMS.CC_PROJECT_ID
PA_DRAFT_INVOICE_ITEMS FK Joins to TablePA_TASKS PA_DRAFT_INVOICE_ITEMS.CC_TAX_TASK_ID
PA_DRAFT_INVOICE_ITEMS FK Joins to TablePA_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
TablePA_CUST_EVENT_RDL_ALL FK Joins to 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
TablePA_CUST_EVENT_RDL_ALL FK Joins to 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
TablePA_CUST_REV_DIST_LINES_ALL FK Joins to 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
TablePA_CUST_REV_DIST_LINES_ALL FK Joins to 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
TablePA_DRAFT_INVOICE_DETAILS_ALL FK Joins to 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
TablePA_DRAFT_INVOICE_DETAILS_ALL FK Joins to 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
TablePA_DRAFT_INVOICE_ITEMS FK Joins to 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
TablePA_DRAFT_INVOICE_ITEMS FK Joins to 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
TablePA_MC_CUST_EVENT_RDL_ALL FK Joins to 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
TablePA_MC_CUST_RDL_ALL FK Joins to 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
TablePA_MC_DRAFT_INV_ITEMS FK Joins to 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
TablePA_MC_RETN_INV_DETAILS FK Joins to 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
TablePA_RETN_INVOICE_DETAILS FK Joins to PA_DRAFT_INVOICE_ITEMS PA_RETN_INVOICE_DETAILS.PROJECT_ID
PA_RETN_INVOICE_DETAILS.DRAFT_INVOICE_NUM
PA_RETN_INVOICE_DETAILS.LINE_NUM