View: GME_RESOURCE_TXNS_V

Product:	GME - Process Manufacturing Process Execution
Description:	This view is used to retrieve Resource transaction for ERES event XML generation
Implementation/DBA Data:	APPS.GME_RESOURCE_TXNS_V

View Text

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

Columns