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]

View: ZX_USR_PROC_NEG_LINE_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ZX_USR_PROC_NEG_LINE_V

View Text

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