VIEW: APPS.ZX_USER_PROC_LINE_INPUT_V

Source

View Text - Preformatted

SELECT 
		ZX_DET_FACT.INTERNAL_ORGANIZATION_ID			Internal_Organization_Id , 
		ZX_DET_FACT.APPLICATION_ID				Application_Id, 
		ZX_DET_FACT.ENTITY_CODE					Entity_Code, 
		ZX_DET_FACT.EVENT_CLASS_CODE				Event_Class_Code, 
		ZX_DET_FACT.TRX_ID					Trx_Id, 
		ZX_PRE_REC_OPT.TAX_PROVIDER_ID				Tax_Provider_Id, 
		ZX_PRE_REC_OPT.TAX_REGIME_CODE				Tax_Regime_Code, 
		ZX_DET_FACT.TRX_LEVEL_TYPE				Trx_Line_Type, 
		ZX_DET_FACT.TRX_LINE_ID					Trx_Line_Id, 
		ZX_DET_FACT.PRODUCT_ID					Product_Id, 
		ZX_DET_FACT.PRODUCT_ORG_ID				Product_Org_Id, 
		ZX_DET_FACT.EXEMPT_CERTIFICATE_NUMBER			Exempt_Certificate_Number, 
		ZX_DET_FACT.EXEMPT_REASON				Exempt_Reason_Code,
		ZX_DET_FACT.EXEMPTION_CONTROL_FLAG			Exemption_Control_Flag,
		ZX_DET_FACT.SHIP_FROM_PARTY_TAX_PROF_ID			Ship_From_Party_Tax_Profile_Id,
		ZX_DET_FACT.SHIP_TO_SITE_TAX_PROF_ID 		        Ship_To_Site_Tax_Prof_Id,
		ZX_DET_FACT.SHIP_TO_PARTY_TAX_PROF_ID			Ship_To_Party_Tax_Profile_Id,
		ZX_DET_FACT.SHIP_TO_LOCATION_ID				Ship_To_Location_Id ,
		ZX_DET_FACT.BILL_TO_CUST_ACCT_SITE_USE_ID		Bill_To_Cust_Acct_Site_Use_Id,
		ZX_DET_FACT.BILL_TO_SITE_TAX_PROF_ID			Bill_To_Site_Tax_Prof_Id,
		ZX_DET_FACT.BILL_TO_PARTY_TAX_PROF_ID			Bill_To_Party_Tax_Prof_Id,
		ZX_DET_FACT.BILL_TO_LOCATION_ID				Bill_To_Location_Id,
		ZX_DET_FACT.LINE_LEVEL_ACTION                           Line_Level_Action,
		ZX_DET_FACT.ADJUSTED_DOC_TRX_ID                         Adjusted_Doc_Trx_Id,
		ZX_DET_FACT.LINE_AMT                                    Line_Amt,
		ZX_DET_FACT.TRADING_HQ_SITE_TAX_PROF_ID                 Trading_Hq_Site_Tax_Prof_Id,
		ZX_DET_FACT.TRADING_HQ_PARTY_TAX_PROF_ID                Trading_Hq_Party_Tax_Prof_Id,
		ZX_DET_FACT.BILL_THIRD_PTY_ACCT_ID                      Bill_Third_Pty_Acct_Id,
		ZX_DET_FACT.ADJUSTED_DOC_APPLICATION_ID                 ADJUSTED_DOC_APPLICATION_ID,
		ZX_DET_FACT.ADJUSTED_DOC_ENTITY_CODE                    ADJUSTED_DOC_ENTITY_CODE, 
		ZX_DET_FACT.ADJUSTED_DOC_EVENT_CLASS_CODE               ADJUSTED_DOC_EVENT_CLASS_CODE,  
		ZX_DET_FACT.ADJUSTED_DOC_TRX_ID                          ADJUSTED_DOC_TRX_LINE_ID ,
		ZX_DET_FACT.RECEIVABLES_TRX_TYPE_ID                     RECEIVABLES_TRX_TYPE_ID
	FROM 
		ZX_LINES_DET_FACTORS     ZX_DET_FACT  , 
		ZX_TRX_PRE_PROC_OPTIONS_GT  ZX_PRE_REC_OPT 
	WHERE
		ZX_DET_FACT.INTERNAL_ORGANIZATION_ID = ZX_PRE_REC_OPT.INTERNAL_ORGANIZATION_ID 
	AND     ZX_DET_FACT.APPLICATION_ID	     = ZX_PRE_REC_OPT.APPLICATION_ID 
	AND     ZX_DET_FACT.EVENT_CLASS_CODE	     = ZX_PRE_REC_OPT.EVENT_CLASS_CODE 
	AND     ZX_DET_FACT.ENTITY_CODE	   	     = ZX_PRE_REC_OPT.ENTITY_CODE 
	AND     ZX_DET_FACT.TRX_ID                   = ZX_PRE_REC_OPT.TRX_ID     

   

View Text - HTML Formatted

SELECT ZX_DET_FACT.INTERNAL_ORGANIZATION_ID INTERNAL_ORGANIZATION_ID
, ZX_DET_FACT.APPLICATION_ID APPLICATION_ID
, ZX_DET_FACT.ENTITY_CODE ENTITY_CODE
, ZX_DET_FACT.EVENT_CLASS_CODE EVENT_CLASS_CODE
, ZX_DET_FACT.TRX_ID TRX_ID
, ZX_PRE_REC_OPT.TAX_PROVIDER_ID TAX_PROVIDER_ID
, ZX_PRE_REC_OPT.TAX_REGIME_CODE TAX_REGIME_CODE
, ZX_DET_FACT.TRX_LEVEL_TYPE TRX_LINE_TYPE
, ZX_DET_FACT.TRX_LINE_ID TRX_LINE_ID
, ZX_DET_FACT.PRODUCT_ID PRODUCT_ID
, ZX_DET_FACT.PRODUCT_ORG_ID PRODUCT_ORG_ID
, ZX_DET_FACT.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER
, ZX_DET_FACT.EXEMPT_REASON EXEMPT_REASON_CODE
, ZX_DET_FACT.EXEMPTION_CONTROL_FLAG EXEMPTION_CONTROL_FLAG
, ZX_DET_FACT.SHIP_FROM_PARTY_TAX_PROF_ID SHIP_FROM_PARTY_TAX_PROFILE_ID
, ZX_DET_FACT.SHIP_TO_SITE_TAX_PROF_ID SHIP_TO_SITE_TAX_PROF_ID
, ZX_DET_FACT.SHIP_TO_PARTY_TAX_PROF_ID SHIP_TO_PARTY_TAX_PROFILE_ID
, ZX_DET_FACT.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, ZX_DET_FACT.BILL_TO_CUST_ACCT_SITE_USE_ID BILL_TO_CUST_ACCT_SITE_USE_ID
, ZX_DET_FACT.BILL_TO_SITE_TAX_PROF_ID BILL_TO_SITE_TAX_PROF_ID
, ZX_DET_FACT.BILL_TO_PARTY_TAX_PROF_ID BILL_TO_PARTY_TAX_PROF_ID
, ZX_DET_FACT.BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, ZX_DET_FACT.LINE_LEVEL_ACTION LINE_LEVEL_ACTION
, ZX_DET_FACT.ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRX_ID
, ZX_DET_FACT.LINE_AMT LINE_AMT
, ZX_DET_FACT.TRADING_HQ_SITE_TAX_PROF_ID TRADING_HQ_SITE_TAX_PROF_ID
, ZX_DET_FACT.TRADING_HQ_PARTY_TAX_PROF_ID TRADING_HQ_PARTY_TAX_PROF_ID
, ZX_DET_FACT.BILL_THIRD_PTY_ACCT_ID BILL_THIRD_PTY_ACCT_ID
, ZX_DET_FACT.ADJUSTED_DOC_APPLICATION_ID ADJUSTED_DOC_APPLICATION_ID
, ZX_DET_FACT.ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_ENTITY_CODE
, ZX_DET_FACT.ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_EVENT_CLASS_CODE
, ZX_DET_FACT.ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRX_LINE_ID
, ZX_DET_FACT.RECEIVABLES_TRX_TYPE_ID RECEIVABLES_TRX_TYPE_ID FROM ZX_LINES_DET_FACTORS ZX_DET_FACT
, ZX_TRX_PRE_PROC_OPTIONS_GT ZX_PRE_REC_OPT WHERE ZX_DET_FACT.INTERNAL_ORGANIZATION_ID = ZX_PRE_REC_OPT.INTERNAL_ORGANIZATION_ID AND ZX_DET_FACT.APPLICATION_ID = ZX_PRE_REC_OPT.APPLICATION_ID AND ZX_DET_FACT.EVENT_CLASS_CODE = ZX_PRE_REC_OPT.EVENT_CLASS_CODE AND ZX_DET_FACT.ENTITY_CODE = ZX_PRE_REC_OPT.ENTITY_CODE AND ZX_DET_FACT.TRX_ID = ZX_PRE_REC_OPT.TRX_ID