ZX_USR_PROC_NEG_LINE

Details

Schema: FUSION
Object owner: FND
Object type: VIEW

Columns

Name
INTERNAL_ORGANIZATION_ID APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE TRX_ID TAX_PROVIDER_ID TAX_REGIME_CODE TRX_LINE_TYPE TRX_LINE_ID PRODUCT_ID PRODUCT_ORG_ID EXEMPT_CERTIFICATE_NUMBER EXEMPT_REASON_CODE EXEMPTION_CONTROL_FLAG SHIP_FROM_PARTY_TAX_PROFILE_ID SHIP_TO_SITE_TAX_PROF_ID SHIP_TO_PARTY_TAX_PROFILE_ID SHIP_TO_LOCATION_ID BILL_TO_CUST_ACCT_SITE_USE_ID BILL_TO_SITE_TAX_PROF_ID BILL_TO_PARTY_TAX_PROF_ID BILL_TO_LOCATION_ID LINE_LEVEL_ACTION ADJUSTED_DOC_TRX_ID LINE_AMT TRADING_HQ_SITE_TAX_PROF_ID TRADING_HQ_PARTY_TAX_PROF_ID BILL_THIRD_PTY_ACCT_ID ADJUSTED_DOC_APPLICATION_ID ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_TRX_LINE_ID ADJUSTED_DOC_TRX_LEVEL_TYPE SHIP_TO_CUST_ACCT_SITE_USE_ID SHIP_THIRD_PTY_ACCT_SITE_ID BILL_THIRD_PTY_ACCT_SITE_ID RECEIVABLES_TRX_TYPE_SEQ_ID TAX_DETERMINE_DATE

Name

INTERNAL_ORGANIZATION_ID

APPLICATION_ID

ENTITY_CODE

EVENT_CLASS_CODE

TRX_ID

TAX_PROVIDER_ID

TAX_REGIME_CODE

TRX_LINE_TYPE

TRX_LINE_ID

PRODUCT_ID

PRODUCT_ORG_ID

EXEMPT_CERTIFICATE_NUMBER

EXEMPT_REASON_CODE

EXEMPTION_CONTROL_FLAG

SHIP_FROM_PARTY_TAX_PROFILE_ID

SHIP_TO_SITE_TAX_PROF_ID

SHIP_TO_PARTY_TAX_PROFILE_ID

SHIP_TO_LOCATION_ID

BILL_TO_CUST_ACCT_SITE_USE_ID

BILL_TO_SITE_TAX_PROF_ID

BILL_TO_PARTY_TAX_PROF_ID

BILL_TO_LOCATION_ID

LINE_LEVEL_ACTION

ADJUSTED_DOC_TRX_ID

LINE_AMT

TRADING_HQ_SITE_TAX_PROF_ID

TRADING_HQ_PARTY_TAX_PROF_ID

BILL_THIRD_PTY_ACCT_ID

ADJUSTED_DOC_APPLICATION_ID

ADJUSTED_DOC_ENTITY_CODE

ADJUSTED_DOC_EVENT_CLASS_CODE

ADJUSTED_DOC_TRX_LINE_ID

ADJUSTED_DOC_TRX_LEVEL_TYPE

SHIP_TO_CUST_ACCT_SITE_USE_ID

SHIP_THIRD_PTY_ACCT_SITE_ID

BILL_THIRD_PTY_ACCT_SITE_ID

RECEIVABLES_TRX_TYPE_SEQ_ID

TAX_DETERMINE_DATE

Query

SQL_Statement
SELECT ZX_NEG_LINE_DET_FACT.INTERNAL_ORGANIZATION_ID , ZX_NEG_LINE_DET_FACT.APPLICATION_ID , ZX_NEG_LINE_DET_FACT.ENTITY_CODE , ZX_NEG_LINE_DET_FACT.EVENT_CLASS_CODE , ZX_NEG_LINE_DET_FACT.TRX_ID , ZX_PRE_REC_OPT.TAX_PROVIDER_ID , ZX_PRE_REC_OPT.TAX_REGIME_CODE , ZX_NEG_LINE_DET_FACT.TRX_LEVEL_TYPE , ZX_NEG_LINE_DET_FACT.TRX_LINE_ID , ZX_NEG_LINE_DET_FACT.PRODUCT_ID , ZX_NEG_LINE_DET_FACT.PRODUCT_ORG_ID , ZX_NEG_LINE_DET_FACT.EXEMPT_CERTIFICATE_NUMBER , ZX_NEG_LINE_DET_FACT.EXEMPT_REASON , ZX_NEG_LINE_DET_FACT.EXEMPTION_CONTROL_FLAG , ZX_NEG_LINE_DET_FACT.SHIP_FROM_PARTY_TAX_PROF_ID , ZX_NEG_LINE_DET_FACT.SHIP_TO_SITE_TAX_PROF_ID , ZX_NEG_LINE_DET_FACT.SHIP_TO_PARTY_TAX_PROF_ID , ZX_NEG_LINE_DET_FACT.SHIP_TO_LOCATION_ID , ZX_NEG_LINE_DET_FACT.BILL_TO_CUST_ACCT_SITE_USE_ID , ZX_NEG_LINE_DET_FACT.BILL_TO_SITE_TAX_PROF_ID , ZX_NEG_LINE_DET_FACT.BILL_TO_PARTY_TAX_PROF_ID , ZX_NEG_LINE_DET_FACT.BILL_TO_LOCATION_ID , ZX_NEG_LINE_DET_FACT.LINE_LEVEL_ACTION , ZX_NEG_LINE_DET_FACT.ADJUSTED_DOC_TRX_ID , ZX_NEG_LINE_DET_FACT.LINE_AMT , ZX_NEG_LINE_DET_FACT.TRADING_HQ_SITE_TAX_PROF_ID , ZX_NEG_LINE_DET_FACT.TRADING_HQ_PARTY_TAX_PROF_ID , ZX_NEG_LINE_DET_FACT.BILL_THIRD_PTY_ACCT_ID , ZX_NEG_LINE_DET_FACT.ADJUSTED_DOC_APPLICATION_ID , ZX_NEG_LINE_DET_FACT.ADJUSTED_DOC_ENTITY_CODE , ZX_NEG_LINE_DET_FACT.ADJUSTED_DOC_EVENT_CLASS_CODE , ZX_NEG_LINE_DET_FACT.ADJUSTED_DOC_LINE_ID , ZX_NEG_LINE_DET_FACT.ADJUSTED_DOC_TRX_LEVEL_TYPE , ZX_NEG_LINE_DET_FACT.SHIP_TO_CUST_ACCT_SITE_USE_ID, ZX_NEG_LINE_DET_FACT.SHIP_THIRD_PTY_ACCT_SITE_ID, ZX_NEG_LINE_DET_FACT.BILL_THIRD_PTY_ACCT_SITE_ID, ZX_NEG_LINE_DET_FACT.RECEIVABLES_TRX_TYPE_SEQ_ID , ZX_NEG_LINE_DET_FACT.TAX_DETERMINE_DATE FROM ZX_PTNR_NEG_LINE_GT ZX_NEG_LINE_DET_FACT , ZX_TRX_PRE_PROC_OPTIONS_GT ZX_PRE_REC_OPT WHERE ZX_NEG_LINE_DET_FACT.INTERNAL_ORGANIZATION_ID = ZX_PRE_REC_OPT.INTERNAL_ORGANIZATION_ID AND ZX_NEG_LINE_DET_FACT.APPLICATION_ID = ZX_PRE_REC_OPT.APPLICATION_ID AND ZX_NEG_LINE_DET_FACT.EVENT_CLASS_CODE = ZX_PRE_REC_OPT.EVENT_CLASS_CODE AND ZX_NEG_LINE_DET_FACT.ENTITY_CODE = ZX_PRE_REC_OPT.ENTITY_CODE AND ZX_NEG_LINE_DET_FACT.TRX_ID = ZX_PRE_REC_OPT.TRX_ID

SQL_Statement

SELECT

ZX_NEG_LINE_DET_FACT.INTERNAL_ORGANIZATION_ID ,

ZX_NEG_LINE_DET_FACT.APPLICATION_ID ,

ZX_NEG_LINE_DET_FACT.ENTITY_CODE ,

ZX_NEG_LINE_DET_FACT.EVENT_CLASS_CODE ,

ZX_NEG_LINE_DET_FACT.TRX_ID ,

ZX_PRE_REC_OPT.TAX_PROVIDER_ID ,

ZX_PRE_REC_OPT.TAX_REGIME_CODE ,

ZX_NEG_LINE_DET_FACT.TRX_LEVEL_TYPE ,

ZX_NEG_LINE_DET_FACT.TRX_LINE_ID ,

ZX_NEG_LINE_DET_FACT.PRODUCT_ID ,

ZX_NEG_LINE_DET_FACT.PRODUCT_ORG_ID ,

ZX_NEG_LINE_DET_FACT.EXEMPT_CERTIFICATE_NUMBER ,

ZX_NEG_LINE_DET_FACT.EXEMPT_REASON ,

ZX_NEG_LINE_DET_FACT.EXEMPTION_CONTROL_FLAG ,

ZX_NEG_LINE_DET_FACT.SHIP_FROM_PARTY_TAX_PROF_ID ,

ZX_NEG_LINE_DET_FACT.SHIP_TO_SITE_TAX_PROF_ID ,

ZX_NEG_LINE_DET_FACT.SHIP_TO_PARTY_TAX_PROF_ID ,

ZX_NEG_LINE_DET_FACT.SHIP_TO_LOCATION_ID ,

ZX_NEG_LINE_DET_FACT.BILL_TO_CUST_ACCT_SITE_USE_ID ,

ZX_NEG_LINE_DET_FACT.BILL_TO_SITE_TAX_PROF_ID ,

ZX_NEG_LINE_DET_FACT.BILL_TO_PARTY_TAX_PROF_ID ,

ZX_NEG_LINE_DET_FACT.BILL_TO_LOCATION_ID ,

ZX_NEG_LINE_DET_FACT.LINE_LEVEL_ACTION ,

ZX_NEG_LINE_DET_FACT.ADJUSTED_DOC_TRX_ID ,

ZX_NEG_LINE_DET_FACT.LINE_AMT ,

ZX_NEG_LINE_DET_FACT.TRADING_HQ_SITE_TAX_PROF_ID ,

ZX_NEG_LINE_DET_FACT.TRADING_HQ_PARTY_TAX_PROF_ID ,

ZX_NEG_LINE_DET_FACT.BILL_THIRD_PTY_ACCT_ID ,

ZX_NEG_LINE_DET_FACT.ADJUSTED_DOC_APPLICATION_ID ,

ZX_NEG_LINE_DET_FACT.ADJUSTED_DOC_ENTITY_CODE ,

ZX_NEG_LINE_DET_FACT.ADJUSTED_DOC_EVENT_CLASS_CODE ,

ZX_NEG_LINE_DET_FACT.ADJUSTED_DOC_LINE_ID ,

ZX_NEG_LINE_DET_FACT.ADJUSTED_DOC_TRX_LEVEL_TYPE ,

ZX_NEG_LINE_DET_FACT.SHIP_TO_CUST_ACCT_SITE_USE_ID,

ZX_NEG_LINE_DET_FACT.SHIP_THIRD_PTY_ACCT_SITE_ID,

ZX_NEG_LINE_DET_FACT.BILL_THIRD_PTY_ACCT_SITE_ID,

ZX_NEG_LINE_DET_FACT.RECEIVABLES_TRX_TYPE_SEQ_ID ,

ZX_NEG_LINE_DET_FACT.TAX_DETERMINE_DATE

FROM

ZX_PTNR_NEG_LINE_GT ZX_NEG_LINE_DET_FACT ,

ZX_TRX_PRE_PROC_OPTIONS_GT ZX_PRE_REC_OPT

WHERE

ZX_NEG_LINE_DET_FACT.INTERNAL_ORGANIZATION_ID = ZX_PRE_REC_OPT.INTERNAL_ORGANIZATION_ID

AND ZX_NEG_LINE_DET_FACT.APPLICATION_ID = ZX_PRE_REC_OPT.APPLICATION_ID

AND ZX_NEG_LINE_DET_FACT.EVENT_CLASS_CODE = ZX_PRE_REC_OPT.EVENT_CLASS_CODE

AND ZX_NEG_LINE_DET_FACT.ENTITY_CODE = ZX_PRE_REC_OPT.ENTITY_CODE

AND ZX_NEG_LINE_DET_FACT.TRX_ID = ZX_PRE_REC_OPT.TRX_ID