VIEW: APPS.CSTBV_MFG_TXN_DISTRIBUTIONS

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ WTA.OVERHEAD_BASIS_FACTOR , WTA.TRANSACTION_DATE , WTA.TRANSACTION_VALUE , WTA.PRIMARY_QUANTITY , WTA.BASE_TRANSACTION_VALUE , WTA.RATE_OR_AMOUNT , '_LA:wta.accounting_line_type:MFG_LOOKUPS:CST_ACCOUNTING_LINE_TYPE:MEANING' , '_LA:wta.basis_type:MFG_LOOKUPS:CST_BASIS:MEANING' , WTA.CURRENCY_CODE , WTA.CURRENCY_CONVERSION_DATE , WTA.CURRENCY_CONVERSION_TYPE , WTA.CURRENCY_CONVERSION_RATE , /* RESOLVE FOREIGN KEY RESOLUTIONS */ /* ID */ WTA.RESOURCE_ID , WTA.ACTIVITY_ID , WTA.REFERENCE_ACCOUNT , WTA.ORGANIZATION_ID , WTA.GL_BATCH_ID , WTA.WIP_ENTITY_ID , WTA.REPETITIVE_SCHEDULE_ID , WTA.TRANSACTION_ID , WTA.CONTRA_SET_ID , WTA.BASIS_RESOURCE_ID , WTA.COST_ELEMENT_ID , /* WHO */ WTA.CREATION_DATE , WTA.CREATED_BY , WTA.LAST_UPDATE_DATE , WTA.LAST_UPDATED_BY FROM WIP_TRANSACTION_ACCOUNTS WTA WHERE '_SEC:wta.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ WTA.OVERHEAD_BASIS_FACTOR
, WTA.TRANSACTION_DATE
, WTA.TRANSACTION_VALUE
, WTA.PRIMARY_QUANTITY
, WTA.BASE_TRANSACTION_VALUE
, WTA.RATE_OR_AMOUNT
, '_LA:WTA.ACCOUNTING_LINE_TYPE:MFG_LOOKUPS:CST_ACCOUNTING_LINE_TYPE:MEANING'
, '_LA:WTA.BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, WTA.CURRENCY_CODE
, WTA.CURRENCY_CONVERSION_DATE
, WTA.CURRENCY_CONVERSION_TYPE
, WTA.CURRENCY_CONVERSION_RATE
, /* RESOLVE FOREIGN KEY RESOLUTIONS */ /* ID */ WTA.RESOURCE_ID
, WTA.ACTIVITY_ID
, WTA.REFERENCE_ACCOUNT
, WTA.ORGANIZATION_ID
, WTA.GL_BATCH_ID
, WTA.WIP_ENTITY_ID
, WTA.REPETITIVE_SCHEDULE_ID
, WTA.TRANSACTION_ID
, WTA.CONTRA_SET_ID
, WTA.BASIS_RESOURCE_ID
, WTA.COST_ELEMENT_ID
, /* WHO */ WTA.CREATION_DATE
, WTA.CREATED_BY
, WTA.LAST_UPDATE_DATE
, WTA.LAST_UPDATED_BY
FROM WIP_TRANSACTION_ACCOUNTS WTA
WHERE '_SEC:WTA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY