Sample SQL Query (You can modify as required):
-----------------------------------
SELECT
PEDT.DEFINITION_NAME
,PEDT.DESCRIPTION
,PEDOB.BASE_DELIVERY_OPTION_NAME
,PEDOB.DATE_TO
,PEDOB.DATE_FROM
,PEDOB.DELIVERY_TYPE
,PEDOB.BIP_REPORT_NAME
,PEDOB.BIP_TEMPLATE_NAME
,PEDOB.OUTPUT_TYPE
,PEDOB.OUTPUT_NAME
,PEDOB.OUTPUT_DIRECTORY_NAME
,PEDOB.FILTER_NODE
,PEDOB.BURSTING_NODE
,PEDOB.LEGISLATION_CODE
,PEDOB.MANDATORY_FLAG
,PEDODP.OPTION_TYPE
,PEDODP.OPTION_VALUE
FROM PER_EXT_DEFINITIONS_TL PEDT, PER_EXT_DELIVERY_OPTIONS_B PEDOB
, PER_EXT_DELIVERY_OPTION_DTLS PEDODP
WHERE PEDT.DEFINITION_NAME LIKE '<pass the HCM Extract Name>'
AND PEDT.EXT_DEFINITION_ID = PEDOB.EXT_DEFINITION_ID
AND PEDOB.EXT_DELIVERY_OPTION_ID = PEDODP.EXT_DELIVERY_OPTION_ID
-----------------------------------
SELECT
PEDT.DEFINITION_NAME
,PEDT.DESCRIPTION
,PEDOB.BASE_DELIVERY_OPTION_NAME
,PEDOB.DATE_TO
,PEDOB.DATE_FROM
,PEDOB.DELIVERY_TYPE
,PEDOB.BIP_REPORT_NAME
,PEDOB.BIP_TEMPLATE_NAME
,PEDOB.OUTPUT_TYPE
,PEDOB.OUTPUT_NAME
,PEDOB.OUTPUT_DIRECTORY_NAME
,PEDOB.FILTER_NODE
,PEDOB.BURSTING_NODE
,PEDOB.LEGISLATION_CODE
,PEDOB.MANDATORY_FLAG
,PEDODP.OPTION_TYPE
,PEDODP.OPTION_VALUE
FROM PER_EXT_DEFINITIONS_TL PEDT, PER_EXT_DELIVERY_OPTIONS_B PEDOB
, PER_EXT_DELIVERY_OPTION_DTLS PEDODP
WHERE PEDT.DEFINITION_NAME LIKE '<pass the HCM Extract Name>'
AND PEDT.EXT_DEFINITION_ID = PEDOB.EXT_DEFINITION_ID
AND PEDOB.EXT_DELIVERY_OPTION_ID = PEDODP.EXT_DELIVERY_OPTION_ID
No comments:
Post a Comment