VIEW: APPS.ZX_USR_PROC_NEG_LINE_V

Source

View Text - Preformatted

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.RECEIVABLES_TRX_TYPE_ID			,
	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
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

View Text - HTML Formatted

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.RECEIVABLES_TRX_TYPE_ID
, 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 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