VIEW: APPS.FII_AP_INV_LINES_FCV

Source

View Text - Preformatted

SELECT APPROVAL_STATUS, SEQ_ID, INV_LINE_PK, UOM_G_FK, UOM_T_FK, ACCOUNTING_DATE_FK, EMPLOYEE_FK, GEOGRAPHY_FK, SUPPLIER_FK, INV_FK, INV_CURRENCY_FK, INSTANCE_FK, INV_SOURCE_FK, ORG_FK, PAYMENT_TERM_FK, SOB_FK, SIC_CODE_FK, DUNS_FK, UNSPSC_FK, ITEM_FK, INV_LINE_TYPE_FK, INSTANCE, MATCH_LINE_COUNT, UNMATCH_LINE_COUNT, INV_LINE_COUNT, MATCH_LINE_AMT_T, MATCH_LINE_AMT_B, MATCH_LINE_AMT_G, UNMATCH_LINE_AMT_T, UNMATCH_LINE_AMT_B, UNMATCH_LINE_AMT_G, INV_LINE_AMT_T, INV_LINE_AMT_B, INV_LINE_AMT_G, INV_UNIT_PRICE_T, INV_UNIT_PRICE_B, INV_UNIT_PRICE_G, PO_UNIT_PRICE_B, PO_UNIT_PRICE_G, PO_UNIT_PRICE_T, TOTAL_VAR_AMT_T, TOTAL_VAR_AMT_B, TOTAL_VAR_AMT_G, ACCOUNTING_DATE, SUPPLIER_SITE_ID, INV_NUM, INV_TYPE, BASE_CURRENCY_CODE, ITEM_ID, CATEGORY_ID, ITEM_DESCRIPTION, PO_DISTRIBUTION_ID, ACCRUAL_POSTED_FLAG, AMT_INCLUDES_TAX_FLAG, ASSETS_TRACKING_FLAG, CASH_POSTED_FLAG, POSTED_FLAG, MATCH_STATUS_FLAG, INV_PRICE_VAR_AMT_T, INV_PRICE_VAR_AMT_B, INV_PRICE_VAR_AMT_G, QTY_VAR_AMT_T, QTY_VAR_AMT_B, QTY_VAR_AMT_G, QUANTITY_INVOICED_T, QUANTITY_INVOICED_G, BATCH_ID, INV_LINE_DESCRIPTION, EXCHANGE_RATE_VAR, INCOME_TAX_REGION, INV_DATE, TYPE_1099, VAT_CODE, ENCUMBERED_FLAG, PROJECT_ID, TASK_ID, EXCHANGE_RATE, EXCHANGE_RATE_TYPE, EXCHANGE_DATE, CASH_JE_BATCH_ID, AWT_FLAG, AWT_GROUP_ID, POSTED_AMT_T, POSTED_AMT_B, POSTED_AMT_G, PO_AMT_T, PO_AMT_B, PO_AMT_G, LAST_UPDATE_DATE, LAST_UPDATE_DATE1, LAST_UPDATE_DATE2, LAST_UPDATE_DATE3, LAST_UPDATE_DATE4, CREATION_DATE, CCID, SET_OF_BOOKS_ID, CHART_OF_ACCOUNTS_ID, GLOBAL_CURRENCY_RATE, PO_NUMBER, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substrb(GL_SEG,1,25)), 'NA_EDW','NA_EDW', rtrim(substrb(GL_SEG,1,25))||substrb(GL_SEG,251))) GL_ACCT1_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substrb(GL_SEG,26,25)), 'NA_EDW','NA_EDW', rtrim(substrb(GL_SEG,26,25))||substrb(GL_SEG,251))) GL_ACCT2_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substrb(GL_SEG,51,25)), 'NA_EDW','NA_EDW', rtrim(substrb(GL_SEG,51,25))||substrb(GL_SEG,251))) GL_ACCT3_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substrb(GL_SEG,76,25)), 'NA_EDW','NA_EDW', rtrim(substrb(GL_SEG,76,25))||substrb(GL_SEG,251))) GL_ACCT4_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substrb(GL_SEG,101,25)), 'NA_EDW','NA_EDW', rtrim(substrb(GL_SEG,101,25))||substrb(GL_SEG,251))) GL_ACCT5_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substrb(GL_SEG,126,25)), 'NA_EDW','NA_EDW', rtrim(substrb(GL_SEG,126,25))||substrb(GL_SEG,251))) GL_ACCT6_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substrb(GL_SEG,151,25)), 'NA_EDW','NA_EDW', rtrim(substrb(GL_SEG,151,25))||substrb(GL_SEG,251))) GL_ACCT7_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substrb(GL_SEG,176,25)), 'NA_EDW','NA_EDW', rtrim(substrb(GL_SEG,176,25))||substrb(GL_SEG,251))) GL_ACCT8_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substrb(GL_SEG,201,25)), 'NA_EDW','NA_EDW', rtrim(substrb(GL_SEG,201,25))||substrb(GL_SEG,251))) GL_ACCT9_FK, decode(GL_SEG, 'NA_EDW', 'NA_EDW', decode(rtrim(substrb(GL_SEG,226,25)), 'NA_EDW','NA_EDW', rtrim(substrb(GL_SEG,226,25))||substrb(GL_SEG,251))) GL_ACCT10_FK, to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, PROJECT_FK, EXPENDITURE_TYPE, VOUCHER_NUMBER, DOC_SEQUENCE_VALUE, RCV_TRANSACTION_ID, INVOICE_DISTRIBUTION_ID, OLD_DIST_LINE_NUMBER FROM ( SELECT APPROVAL_STATUS, SEQ_ID, INV_LINE_PK, UOM_G_FK, UOM_T_FK, ACCOUNTING_DATE_FK, EMPLOYEE_FK, GEOGRAPHY_FK, SUPPLIER_FK, INV_FK, INV_CURRENCY_FK, INSTANCE_FK, INV_SOURCE_FK, ORG_FK, PAYMENT_TERM_FK, SOB_FK, SIC_CODE_FK, DUNS_FK, UNSPSC_FK, ITEM_FK, INV_LINE_TYPE_FK, INSTANCE, MATCH_LINE_COUNT, UNMATCH_LINE_COUNT, INV_LINE_COUNT, MATCH_LINE_AMT_T, MATCH_LINE_AMT_B, MATCH_LINE_AMT_G, UNMATCH_LINE_AMT_T, UNMATCH_LINE_AMT_B, UNMATCH_LINE_AMT_G, INV_LINE_AMT_T, INV_LINE_AMT_B, INV_LINE_AMT_G, INV_UNIT_PRICE_T, INV_UNIT_PRICE_B, INV_UNIT_PRICE_G, PO_UNIT_PRICE_B, PO_UNIT_PRICE_G, PO_UNIT_PRICE_T, TOTAL_VAR_AMT_T, TOTAL_VAR_AMT_B, TOTAL_VAR_AMT_G, ACCOUNTING_DATE, SUPPLIER_SITE_ID, INV_NUM, INV_TYPE, BASE_CURRENCY_CODE, ITEM_ID, CATEGORY_ID, ITEM_DESCRIPTION, PO_DISTRIBUTION_ID, ACCRUAL_POSTED_FLAG, AMT_INCLUDES_TAX_FLAG, ASSETS_TRACKING_FLAG, CASH_POSTED_FLAG, POSTED_FLAG, MATCH_STATUS_FLAG, INV_PRICE_VAR_AMT_T, INV_PRICE_VAR_AMT_B, INV_PRICE_VAR_AMT_G, QTY_VAR_AMT_T, QTY_VAR_AMT_B, QTY_VAR_AMT_G, QUANTITY_INVOICED_T, QUANTITY_INVOICED_G, BATCH_ID, INV_LINE_DESCRIPTION, EXCHANGE_RATE_VAR, INCOME_TAX_REGION, INV_DATE, TYPE_1099, VAT_CODE, ENCUMBERED_FLAG, PROJECT_ID, TASK_ID, EXCHANGE_RATE, EXCHANGE_RATE_TYPE, EXCHANGE_DATE, CASH_JE_BATCH_ID, AWT_FLAG, AWT_GROUP_ID, POSTED_AMT_T, POSTED_AMT_B, POSTED_AMT_G, PO_AMT_T, PO_AMT_B, PO_AMT_G, LAST_UPDATE_DATE, LAST_UPDATE_DATE1, LAST_UPDATE_DATE2, LAST_UPDATE_DATE3, LAST_UPDATE_DATE4, CREATION_DATE, CCID, SET_OF_BOOKS_ID, GLOBAL_CURRENCY_RATE, CHART_OF_ACCOUNTS_ID, PO_NUMBER, fii_flex_mapping.get_value( CCID, SET_OF_BOOKS_ID, CHART_OF_ACCOUNTS_ID ) GL_SEG, PROJECT_FK, EXPENDITURE_TYPE, VOUCHER_NUMBER, DOC_SEQUENCE_VALUE, RCV_TRANSACTION_ID, INVOICE_DISTRIBUTION_ID, OLD_DIST_LINE_NUMBER FROM FIIBV_AP_INV_LINES_FCV)

View Text - HTML Formatted

SELECT APPROVAL_STATUS
, SEQ_ID
, INV_LINE_PK
, UOM_G_FK
, UOM_T_FK
, ACCOUNTING_DATE_FK
, EMPLOYEE_FK
, GEOGRAPHY_FK
, SUPPLIER_FK
, INV_FK
, INV_CURRENCY_FK
, INSTANCE_FK
, INV_SOURCE_FK
, ORG_FK
, PAYMENT_TERM_FK
, SOB_FK
, SIC_CODE_FK
, DUNS_FK
, UNSPSC_FK
, ITEM_FK
, INV_LINE_TYPE_FK
, INSTANCE
, MATCH_LINE_COUNT
, UNMATCH_LINE_COUNT
, INV_LINE_COUNT
, MATCH_LINE_AMT_T
, MATCH_LINE_AMT_B
, MATCH_LINE_AMT_G
, UNMATCH_LINE_AMT_T
, UNMATCH_LINE_AMT_B
, UNMATCH_LINE_AMT_G
, INV_LINE_AMT_T
, INV_LINE_AMT_B
, INV_LINE_AMT_G
, INV_UNIT_PRICE_T
, INV_UNIT_PRICE_B
, INV_UNIT_PRICE_G
, PO_UNIT_PRICE_B
, PO_UNIT_PRICE_G
, PO_UNIT_PRICE_T
, TOTAL_VAR_AMT_T
, TOTAL_VAR_AMT_B
, TOTAL_VAR_AMT_G
, ACCOUNTING_DATE
, SUPPLIER_SITE_ID
, INV_NUM
, INV_TYPE
, BASE_CURRENCY_CODE
, ITEM_ID
, CATEGORY_ID
, ITEM_DESCRIPTION
, PO_DISTRIBUTION_ID
, ACCRUAL_POSTED_FLAG
, AMT_INCLUDES_TAX_FLAG
, ASSETS_TRACKING_FLAG
, CASH_POSTED_FLAG
, POSTED_FLAG
, MATCH_STATUS_FLAG
, INV_PRICE_VAR_AMT_T
, INV_PRICE_VAR_AMT_B
, INV_PRICE_VAR_AMT_G
, QTY_VAR_AMT_T
, QTY_VAR_AMT_B
, QTY_VAR_AMT_G
, QUANTITY_INVOICED_T
, QUANTITY_INVOICED_G
, BATCH_ID
, INV_LINE_DESCRIPTION
, EXCHANGE_RATE_VAR
, INCOME_TAX_REGION
, INV_DATE
, TYPE_1099
, VAT_CODE
, ENCUMBERED_FLAG
, PROJECT_ID
, TASK_ID
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, EXCHANGE_DATE
, CASH_JE_BATCH_ID
, AWT_FLAG
, AWT_GROUP_ID
, POSTED_AMT_T
, POSTED_AMT_B
, POSTED_AMT_G
, PO_AMT_T
, PO_AMT_B
, PO_AMT_G
, LAST_UPDATE_DATE
, LAST_UPDATE_DATE1
, LAST_UPDATE_DATE2
, LAST_UPDATE_DATE3
, LAST_UPDATE_DATE4
, CREATION_DATE
, CCID
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID
, GLOBAL_CURRENCY_RATE
, PO_NUMBER
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 1
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 1
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT1_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 26
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 26
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT2_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 51
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 51
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT3_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 76
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 76
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT4_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 101
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 101
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT5_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 126
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 126
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT6_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 151
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 151
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT7_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 176
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 176
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT8_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 201
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 201
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT9_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 226
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 226
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT10_FK
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PROJECT_FK
, EXPENDITURE_TYPE
, VOUCHER_NUMBER
, DOC_SEQUENCE_VALUE
, RCV_TRANSACTION_ID
, INVOICE_DISTRIBUTION_ID
, OLD_DIST_LINE_NUMBER
FROM ( SELECT APPROVAL_STATUS
, SEQ_ID
, INV_LINE_PK
, UOM_G_FK
, UOM_T_FK
, ACCOUNTING_DATE_FK
, EMPLOYEE_FK
, GEOGRAPHY_FK
, SUPPLIER_FK
, INV_FK
, INV_CURRENCY_FK
, INSTANCE_FK
, INV_SOURCE_FK
, ORG_FK
, PAYMENT_TERM_FK
, SOB_FK
, SIC_CODE_FK
, DUNS_FK
, UNSPSC_FK
, ITEM_FK
, INV_LINE_TYPE_FK
, INSTANCE
, MATCH_LINE_COUNT
, UNMATCH_LINE_COUNT
, INV_LINE_COUNT
, MATCH_LINE_AMT_T
, MATCH_LINE_AMT_B
, MATCH_LINE_AMT_G
, UNMATCH_LINE_AMT_T
, UNMATCH_LINE_AMT_B
, UNMATCH_LINE_AMT_G
, INV_LINE_AMT_T
, INV_LINE_AMT_B
, INV_LINE_AMT_G
, INV_UNIT_PRICE_T
, INV_UNIT_PRICE_B
, INV_UNIT_PRICE_G
, PO_UNIT_PRICE_B
, PO_UNIT_PRICE_G
, PO_UNIT_PRICE_T
, TOTAL_VAR_AMT_T
, TOTAL_VAR_AMT_B
, TOTAL_VAR_AMT_G
, ACCOUNTING_DATE
, SUPPLIER_SITE_ID
, INV_NUM
, INV_TYPE
, BASE_CURRENCY_CODE
, ITEM_ID
, CATEGORY_ID
, ITEM_DESCRIPTION
, PO_DISTRIBUTION_ID
, ACCRUAL_POSTED_FLAG
, AMT_INCLUDES_TAX_FLAG
, ASSETS_TRACKING_FLAG
, CASH_POSTED_FLAG
, POSTED_FLAG
, MATCH_STATUS_FLAG
, INV_PRICE_VAR_AMT_T
, INV_PRICE_VAR_AMT_B
, INV_PRICE_VAR_AMT_G
, QTY_VAR_AMT_T
, QTY_VAR_AMT_B
, QTY_VAR_AMT_G
, QUANTITY_INVOICED_T
, QUANTITY_INVOICED_G
, BATCH_ID
, INV_LINE_DESCRIPTION
, EXCHANGE_RATE_VAR
, INCOME_TAX_REGION
, INV_DATE
, TYPE_1099
, VAT_CODE
, ENCUMBERED_FLAG
, PROJECT_ID
, TASK_ID
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, EXCHANGE_DATE
, CASH_JE_BATCH_ID
, AWT_FLAG
, AWT_GROUP_ID
, POSTED_AMT_T
, POSTED_AMT_B
, POSTED_AMT_G
, PO_AMT_T
, PO_AMT_B
, PO_AMT_G
, LAST_UPDATE_DATE
, LAST_UPDATE_DATE1
, LAST_UPDATE_DATE2
, LAST_UPDATE_DATE3
, LAST_UPDATE_DATE4
, CREATION_DATE
, CCID
, SET_OF_BOOKS_ID
, GLOBAL_CURRENCY_RATE
, CHART_OF_ACCOUNTS_ID
, PO_NUMBER
, FII_FLEX_MAPPING.GET_VALUE( CCID
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID ) GL_SEG
, PROJECT_FK
, EXPENDITURE_TYPE
, VOUCHER_NUMBER
, DOC_SEQUENCE_VALUE
, RCV_TRANSACTION_ID
, INVOICE_DISTRIBUTION_ID
, OLD_DIST_LINE_NUMBER
FROM FIIBV_AP_INV_LINES_FCV)