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: OZF_FUND_CHECKBOOK_V

Product:	OZF - Trade Management
Description:
Implementation/DBA Data:	APPS.OZF_FUND_CHECKBOOK_V

View Text

SELECT DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ACT_BUDGET_USED_BY_ID
, ACT1.BUDGET_SOURCE_ID)
, A.CAMPAIGN_NAME
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ARC_ACT_BUDGET_USED_BY
, ACT1.BUDGET_SOURCE_TYPE)
, A.CUSTOM_SETUP_ID
, A.SOURCE_CODE
, A.STATUS_CODE
, DECODE(ACT1.STATUS_CODE
, 'APPROVED'
, DECODE ( ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.APPROVED_AMOUNT
, 0-ACT1.APPROVED_AMOUNT))
, DECODE (ACT1.STATUS_CODE
, 'PENDING'
, ACT1.REQUEST_AMOUNT)
, A.OWNER_USER_ID
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.BUDGET_SOURCE_ID
, ACT1.ACT_BUDGET_USED_BY_ID)
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.BUDGET_SOURCE_TYPE
, ACT1.ARC_ACT_BUDGET_USED_BY)
, A.ACTUAL_EXEC_START_DATE
, A.ACTUAL_EXEC_END_DATE
, ACT1.REQUEST_CURRENCY
, TO_NUMBER(NULL)
, NULL COMPONENT_TYPE
, NULL COMPONENT_NUMBER
, NULL COMPONENT_TYPE_CODE
, NULL COMPONENT_NAME
, ACT1.PARENT_SOURCE_ID
, ACT1.PARENT_SRC_CURR
, DECODE ( ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.PARENT_SRC_APPRVD_AMT
, 0-ACT1.PARENT_SRC_APPRVD_AMT)
, ACT1.STATUS_CODE
, ACT1.TRANSFER_TYPE
FROM AMS_CAMPAIGNS_VL A
, AMS_ACT_BUDGETS ACT1
WHERE DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ACT_BUDGET_USED_BY_ID
, ACT1.BUDGET_SOURCE_ID) = A.CAMPAIGN_ID
AND DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ARC_ACT_BUDGET_USED_BY
, ACT1.BUDGET_SOURCE_TYPE) ='CAMP'
AND ACT1.ARC_ACT_BUDGET_USED_BY <> ACT1.BUDGET_SOURCE_TYPE
AND ACT1.STATUS_CODE IN ('APPROVED'
, 'PENDING') UNION ALL SELECT SCH.CAMPAIGN_ID
, A.CAMPAIGN_NAME
, 'CAMP'
, A.CUSTOM_SETUP_ID
, A.SOURCE_CODE
, A.STATUS_CODE
, DECODE(ACT1.STATUS_CODE
, 'APPROVED'
, DECODE ( ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.APPROVED_AMOUNT
, 0-ACT1.APPROVED_AMOUNT))
, DECODE(ACT1.STATUS_CODE
, 'PENDING'
, ACT1.REQUEST_AMOUNT)
, A.OWNER_USER_ID
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.BUDGET_SOURCE_ID
, ACT1.ACT_BUDGET_USED_BY_ID)
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.BUDGET_SOURCE_TYPE
, ACT1.ARC_ACT_BUDGET_USED_BY)
, A.ACTUAL_EXEC_START_DATE
, A.ACTUAL_EXEC_END_DATE
, ACT1.REQUEST_CURRENCY
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ACT_BUDGET_USED_BY_ID
, ACT1.BUDGET_SOURCE_ID)
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ARC_ACT_BUDGET_USED_BY
, ACT1.BUDGET_SOURCE_TYPE)
, SCH.SOURCE_CODE
, SCH.ACTIVITY_TYPE_CODE
, SCH.SCHEDULE_NAME
, ACT1.PARENT_SOURCE_ID
, ACT1.PARENT_SRC_CURR
, DECODE ( ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.PARENT_SRC_APPRVD_AMT
, 0-ACT1.PARENT_SRC_APPRVD_AMT)
, ACT1.STATUS_CODE
, ACT1.TRANSFER_TYPE
FROM AMS_CAMPAIGNS_VL A
, AMS_ACT_BUDGETS ACT1
, AMS_CAMPAIGN_SCHEDULES_VL SCH
WHERE DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ACT_BUDGET_USED_BY_ID
, ACT1.BUDGET_SOURCE_ID) = SCH.SCHEDULE_ID
AND DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ARC_ACT_BUDGET_USED_BY
, ACT1.BUDGET_SOURCE_TYPE) ='CSCH'
AND SCH.CAMPAIGN_ID = A.CAMPAIGN_ID
AND ACT1.BUDGET_SOURCE_TYPE <> ACT1.ARC_ACT_BUDGET_USED_BY
AND ACT1.STATUS_CODE IN ('APPROVED'
, 'PENDING') UNION ALL SELECT ACTOF.ACT_OFFER_USED_BY_ID
, A.CAMPAIGN_NAME
, 'CAMP'
, A.CUSTOM_SETUP_ID
, A.SOURCE_CODE
, A.STATUS_CODE
, DECODE(ACT1.STATUS_CODE
, 'APPROVED'
, DECODE ( ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.APPROVED_AMOUNT
, 0-ACT1.APPROVED_AMOUNT))
, DECODE (ACT1.STATUS_CODE
, 'PENDING'
, ACT1.REQUEST_AMOUNT)
, A.OWNER_USER_ID
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.BUDGET_SOURCE_ID
, ACT1.ACT_BUDGET_USED_BY_ID)
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.BUDGET_SOURCE_TYPE
, ACT1.ARC_ACT_BUDGET_USED_BY)
, A.ACTUAL_EXEC_START_DATE
, A.ACTUAL_EXEC_END_DATE
, ACT1.REQUEST_CURRENCY
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ACT_BUDGET_USED_BY_ID
, ACT1.BUDGET_SOURCE_ID)
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ARC_ACT_BUDGET_USED_BY
, ACT1.BUDGET_SOURCE_TYPE)
, OFFS.OFFER_CODE
, OFFS.OFFER_TYPE
, OFFS.OFFER_CODE
, ACT1.PARENT_SOURCE_ID
, ACT1.PARENT_SRC_CURR
, DECODE ( ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.PARENT_SRC_APPRVD_AMT
, 0-ACT1.PARENT_SRC_APPRVD_AMT)
, ACT1.STATUS_CODE
, ACT1.TRANSFER_TYPE
FROM AMS_CAMPAIGNS_VL A
, AMS_ACT_BUDGETS ACT1
, AMS_ACT_OFFERS ACTOF
, AMS_OFFERS OFFS
WHERE DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ACT_BUDGET_USED_BY_ID
, ACT1.BUDGET_SOURCE_ID) = OFFS.QP_LIST_HEADER_ID
AND DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ARC_ACT_BUDGET_USED_BY
, ACT1.BUDGET_SOURCE_TYPE) ='OFFR'
AND ACTOF.ACT_OFFER_USED_BY_ID = A.CAMPAIGN_ID
AND ACTOF.ARC_ACT_OFFER_USED_BY = 'CAMP'
AND ACT1.BUDGET_SOURCE_TYPE <> ACT1.ARC_ACT_BUDGET_USED_BY
AND ACT1.STATUS_CODE IN ('APPROVED'
, 'PENDING')
AND ACTOF.QP_LIST_HEADER_ID = OFFS.QP_LIST_HEADER_ID UNION ALL SELECT DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ACT_BUDGET_USED_BY_ID
, ACT1.BUDGET_SOURCE_ID)
, A.EVENT_HEADER_NAME
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ARC_ACT_BUDGET_USED_BY
, ACT1.BUDGET_SOURCE_TYPE)
, A.SETUP_TYPE_ID
, A.SOURCE_CODE
, A.SYSTEM_STATUS_CODE
, DECODE(ACT1.STATUS_CODE
, 'APPROVED'
, DECODE ( ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.APPROVED_AMOUNT
, 0-ACT1.APPROVED_AMOUNT))
, DECODE (ACT1.STATUS_CODE
, 'PENDING'
, ACT1.REQUEST_AMOUNT)
, A.OWNER_USER_ID
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.BUDGET_SOURCE_ID
, ACT1.ACT_BUDGET_USED_BY_ID)
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.BUDGET_SOURCE_TYPE
, ACT1.ARC_ACT_BUDGET_USED_BY)
, A.ACTIVE_FROM_DATE
, A.ACTIVE_TO_DATE
, ACT1.REQUEST_CURRENCY
, TO_NUMBER(NULL)
, NULL COMPONENT_TYPE
, NULL COMPONENT_NUMBER
, NULL COMPONENT_TYPE_CODE
, NULL COMPONENT_NAME
, ACT1.PARENT_SOURCE_ID
, ACT1.PARENT_SRC_CURR
, DECODE ( ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.PARENT_SRC_APPRVD_AMT
, 0-ACT1.PARENT_SRC_APPRVD_AMT)
, ACT1.STATUS_CODE
, ACT1.TRANSFER_TYPE
FROM AMS_EVENT_HEADERS_VL A
, AMS_ACT_BUDGETS ACT1
WHERE DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ACT_BUDGET_USED_BY_ID
, ACT1.BUDGET_SOURCE_ID) = A.EVENT_HEADER_ID
AND DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ARC_ACT_BUDGET_USED_BY
, ACT1.BUDGET_SOURCE_TYPE) ='EVEH'
AND ACT1.ACT_BUDGET_USED_BY_ID = A.EVENT_HEADER_ID
AND ACT1.STATUS_CODE IN ('APPROVED'
, 'PENDING') UNION ALL SELECT DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ACT_BUDGET_USED_BY_ID
, ACT1.BUDGET_SOURCE_ID)
, A.EVENT_OFFER_NAME
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ARC_ACT_BUDGET_USED_BY
, ACT1.BUDGET_SOURCE_TYPE)
, TO_NUMBER(NULL)
, A.SOURCE_CODE
, A.SYSTEM_STATUS_CODE
, DECODE(ACT1.STATUS_CODE
, 'APPROVED'
, DECODE ( ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.APPROVED_AMOUNT
, 0-ACT1.APPROVED_AMOUNT))
, DECODE (ACT1.STATUS_CODE
, 'PENDING'
, ACT1.REQUEST_AMOUNT)
, A.OWNER_USER_ID
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.BUDGET_SOURCE_ID
, ACT1.ACT_BUDGET_USED_BY_ID)
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.BUDGET_SOURCE_TYPE
, ACT1.ARC_ACT_BUDGET_USED_BY)
, A.EVENT_START_DATE
, A.EVENT_END_DATE
, ACT1.REQUEST_CURRENCY
, TO_NUMBER(NULL)
, NULL COMPONENT_TYPE
, NULL COMPONENT_NUMBER
, NULL COMPONENT_TYPE_CODE
, NULL COMPONENT_NAME
, ACT1.PARENT_SOURCE_ID
, ACT1.PARENT_SRC_CURR
, DECODE ( ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.PARENT_SRC_APPRVD_AMT
, 0-ACT1.PARENT_SRC_APPRVD_AMT)
, ACT1.STATUS_CODE
, ACT1.TRANSFER_TYPE
FROM AMS_EVENT_OFFERS_VL A
, AMS_ACT_BUDGETS ACT1
WHERE DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ACT_BUDGET_USED_BY_ID
, ACT1.BUDGET_SOURCE_ID) = A.EVENT_OFFER_ID
AND DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ARC_ACT_BUDGET_USED_BY
, ACT1.BUDGET_SOURCE_TYPE) ='EVEO'
AND ACT1.BUDGET_SOURCE_TYPE <> ACT1.ARC_ACT_BUDGET_USED_BY
AND ACT1.STATUS_CODE IN('APPROVED'
, 'PENDING') UNION ALL SELECT DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ACT_BUDGET_USED_BY_ID
, ACT1.BUDGET_SOURCE_ID)
, A.DELIVERABLE_NAME
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ARC_ACT_BUDGET_USED_BY
, ACT1.BUDGET_SOURCE_TYPE)
, A.CUSTOM_SETUP_ID
, A.VERSION SOURCE_CODE
, A.STATUS_CODE
, DECODE(ACT1.STATUS_CODE
, 'APPROVED'
, DECODE ( ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.APPROVED_AMOUNT
, 0-ACT1.APPROVED_AMOUNT))
, DECODE (ACT1.STATUS_CODE
, 'PENDING'
, ACT1.REQUEST_AMOUNT)
, A.OWNER_USER_ID
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.BUDGET_SOURCE_ID
, ACT1.ACT_BUDGET_USED_BY_ID)
, DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.BUDGET_SOURCE_TYPE
, ACT1.ARC_ACT_BUDGET_USED_BY)
, A.ACTUAL_AVAIL_FROM_DATE
, A.ACTUAL_AVAIL_TO_DATE
, ACT1.REQUEST_CURRENCY
, TO_NUMBER(NULL)
, NULL COMPONENT_TYPE
, NULL COMPONENT_NUMBER
, NULL COMPONENT_TYPE_CODE
, NULL COMPONENT_NAME
, ACT1.PARENT_SOURCE_ID
, ACT1.PARENT_SRC_CURR
, DECODE ( ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.PARENT_SRC_APPRVD_AMT
, 0-ACT1.PARENT_SRC_APPRVD_AMT)
, ACT1.STATUS_CODE
, ACT1.TRANSFER_TYPE
FROM AMS_DELIVERABLES_VL A
, AMS_ACT_BUDGETS ACT1
WHERE DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ACT_BUDGET_USED_BY_ID
, ACT1.BUDGET_SOURCE_ID) = A.DELIVERABLE_ID
AND DECODE(ACT1.TRANSFER_TYPE
, 'REQUEST'
, ACT1.ARC_ACT_BUDGET_USED_BY
, ACT1.BUDGET_SOURCE_TYPE) = 'DELV'
AND ACT1.BUDGET_SOURCE_TYPE <> ACT1.ARC_ACT_BUDGET_USED_BY
AND ACT1.STATUS_CODE IN ('APPROVED'
, 'PENDING')

Columns

Name
OBJECT_ID
OBJECT_NAME
OBJECT_TYPE_CODE
CUSTOM_SETUP_ID
SOURCE_CODE
STATUS_CODE
COMMITTED_BUDGET
PLANNED_BUDGET
OBJECT_OWNER
SOURCE_ID
SOURCE_TYPE
OBJECT_EXEC_DATE
OBJECT_END_DATE
OBJECT_CURRENCY
COMPONENT_ID
COMPONENT_TYPE
COMPONENT_NUMBER
COMPONENT_TYPE_CODE
COMPONENT_NAME
PARENT_SOURCE_ID
PARENT_SRC_CURR
PARENT_SRC_APPRVD_AMT
OBJ_STATUS_CODE
TRANSFER_TYPE