VIEW: APPS.GME_RESOURCE_TXNS_V

Source

View Text - Preformatted

SELECT rsrc_trns.POC_TRANS_ID ,MP.ORGANIZATION_CODE ORGN_CODE ,rsrc_trns.DOC_TYPE ,rsrc_trns.DOC_ID ,rsrc_trns.LINE_TYPE ,rsrc_trns.LINE_ID ,rsrc_trns.RESOURCES ,Decode(rsrc_trns.action_code,'UPD',TRNS.RESOURCE_USAGE - rsrc_trns.RESOURCE_USAGE, 'ADD',rsrc_trns.RESOURCE_USAGE, 'DEL',rsrc_trns.RESOURCE_USAGE * -1) ,rsrc_trns.TRANS_DATE ,FND_DATE.DATE_TO_DISPLAYDT(rsrc_trns.TRANS_DATE, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) ,rsrc_trns.COMPLETED_IND ,rsrc_trns.EVENT_ID ,rsrc_trns.POSTED_IND ,rsrc_trns.OVERRIDED_PROTECTED_IND ,rsrc_trns.REASON_ID ,MTR.REASON_NAME ,rsrc_trns.START_DATE ,rsrc_trns.END_DATE ,FND_DATE.DATE_TO_DISPLAYDT(rsrc_trns.START_DATE, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) ,FND_DATE.DATE_TO_DISPLAYDT(rsrc_trns.END_DATE, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) ,rsrc_trns.INSTANCE_ID ,rsrc_trns.ORGANIZATION_ID ,rsrc_trns.TRANS_UM FROM GME_RESOURCE_TXNS_GTMP rsrc_trns, GME_RESOURCE_TXNS TRNS, MTL_PARAMETERS MP, MTL_TRANSACTION_REASONS MTR WHERE MP.ORGANIZATION_ID = rsrc_trns.ORGANIZATION_ID and rsrc_trns.action_code <> 'NONE' AND rsrc_trns.POC_TRANS_ID = TRNS.POC_TRANS_ID(+) AND MTR.REASON_ID (+) = rsrc_trns.REASON_ID

View Text - HTML Formatted

SELECT RSRC_TRNS.POC_TRANS_ID
, MP.ORGANIZATION_CODE ORGN_CODE
, RSRC_TRNS.DOC_TYPE
, RSRC_TRNS.DOC_ID
, RSRC_TRNS.LINE_TYPE
, RSRC_TRNS.LINE_ID
, RSRC_TRNS.RESOURCES
, DECODE(RSRC_TRNS.ACTION_CODE
, 'UPD'
, TRNS.RESOURCE_USAGE - RSRC_TRNS.RESOURCE_USAGE
, 'ADD'
, RSRC_TRNS.RESOURCE_USAGE
, 'DEL'
, RSRC_TRNS.RESOURCE_USAGE * -1)
, RSRC_TRNS.TRANS_DATE
, FND_DATE.DATE_TO_DISPLAYDT(RSRC_TRNS.TRANS_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, RSRC_TRNS.COMPLETED_IND
, RSRC_TRNS.EVENT_ID
, RSRC_TRNS.POSTED_IND
, RSRC_TRNS.OVERRIDED_PROTECTED_IND
, RSRC_TRNS.REASON_ID
, MTR.REASON_NAME
, RSRC_TRNS.START_DATE
, RSRC_TRNS.END_DATE
, FND_DATE.DATE_TO_DISPLAYDT(RSRC_TRNS.START_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, FND_DATE.DATE_TO_DISPLAYDT(RSRC_TRNS.END_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, RSRC_TRNS.INSTANCE_ID
, RSRC_TRNS.ORGANIZATION_ID
, RSRC_TRNS.TRANS_UM
FROM GME_RESOURCE_TXNS_GTMP RSRC_TRNS
, GME_RESOURCE_TXNS TRNS
, MTL_PARAMETERS MP
, MTL_TRANSACTION_REASONS MTR
WHERE MP.ORGANIZATION_ID = RSRC_TRNS.ORGANIZATION_ID
AND RSRC_TRNS.ACTION_CODE <> 'NONE'
AND RSRC_TRNS.POC_TRANS_ID = TRNS.POC_TRANS_ID(+)
AND MTR.REASON_ID (+) = RSRC_TRNS.REASON_ID