GL : Interface Summary:-
-----------------------------
GL INTERFACE SUMMARY
Shows summary by source, book, request_id and group_id of the transactions in the GL interface across multiple sets of books
This can be used for ad-hoc queries such as month and or to include in automated Oracle alerts
I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.
I have commented the SOB condition. Check your Instances SOB short-name and provide accordingly if you have multiple SOB in your business Structure.
SELECT SOB.SHORT_NAME"BOOK NAME"
, GLI.USER_JE_SOURCE_NAME "JRNL SOURCE"
, GLI.SET_OF_BOOKS_ID "BOOKS ID"
--, TRUNC(ACCOUNTING_DATE)"GL DATE"
, PERIOD_NAME"PERIOD"
, GLI.STATUS
, GLI.GROUP_ID
, GLI.REQUEST_ID
, TRUNC(GLI.DATE_CREATED) "CREATED DATE"
--,GLI.DATE_CREATED
, TRUNC(GLI.ACCOUNTING_DATE)"GL DATE"
, COUNT(*)
FROM GL_INTERFACE GLI, GL_SETS_OF_BOOKS SOB
WHERE SOB.SET_OF_BOOKS_ID(+) = GLI.SET_OF_BOOKS_ID
--AND GLI.USER_JE_SOURCE_NAME = 'HR'
AND GLI.USER_JE_SOURCE_NAME = 'Receivables'
--AND TRUNC(GLI.DATE_CREATED) > '01-DEC-2005'
--AND GLI.USER_JE_SOURCE_NAME = 'PAYROLL'
--AND SUBSTR(SOB.SHORT_NAME,1,2) IN ('HB')
GROUP BY SOB.SHORT_NAME,GLI.USER_JE_SOURCE_NAME, GLI.SET_OF_BOOKS_ID,
PERIOD_NAME, GLI.STATUS, GLI.GROUP_ID, TRUNC(GLI.DATE_CREATED),TRUNC(ACCOUNTING_DATE)--,GLI.DATE_CREATED
, GLI.REQUEST_ID
--,GLI.DATE_CREATED
--ORDER BY GLI.DATE_CREATED
Sunday, August 3, 2008
Interface Details
GL : Interface Details:-
--------------------------
GL INTERFACE DETAIL
Shows transactions level detail with full accounting and status information for each line in the GL interface across multiple sets of books
Can be used for SOX and system audits.
I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.
I have commented the SOB, Curreny condition etc. Check your Instances SOB short-name and for the currencies you want to run if it is needed
The following query is made to run for all the currenies and SOB's
SELECT SOB.SHORT_NAME "BOOK"
, GLI.SET_OF_BOOKS_ID "SOB ID"
, TRUNC(GLI.ACCOUNTING_DATE) "GL DATE"
, GLI.CURRENCY_CODE "CUR"
, GLI.USER_JE_CATEGORY_NAME "JE CATEGOTY"
, GLI.USER_JE_SOURCE_NAME "JE SOURCE"
, GLI.ENTERED_DR "ENT DR"
, GLI.ENTERED_CR "ENT CR"
, GLI.ACCOUNTED_DR "ACC DR"
, GLI.ACCOUNTED_CR "ACC CR"
, GLI.SEGMENT1||'.'||GLI.SEGMENT2||'.'||GLI.SEGMENT3||'.'||GLI.SEGMENT4||'.'||GLI.SEGMENT5
||'.'||GLI.SEGMENT6||'.'||GLI.SEGMENT7||'.'||GLI.SEGMENT8||'.'||GLI.SEGMENT9||'.'||GLI.SEGMENT10 "ACCOUNT COMB."
, GLI.REFERENCE1 "REF 1"
, GLI.REFERENCE2 "REF 2"
, GLI.REFERENCE4 "REF 4"
, GLI.REFERENCE7 "REF 7"
, GLI.REFERENCE10 "REF 10"
, GLI.WARNING_CODE
, GLI.STATUS_DESCRIPTION
, GLI.STATUS
FROM GL_INTERFACE GLI, GL_SETS_OF_BOOKS SOB
WHERE SOB.SET_OF_BOOKS_ID(+) = GLI.SET_OF_BOOKS_ID
--AND GLI.WARNING_CODE IS NOT NULL
--AND GLI.STATUS <> 'P'
and GLI.USER_JE_SOURCE_NAME = 'Payables'
and trunc(GLI.DATE_CREATED) > '01-JAN-2008'
--and GLI.CURRENCY_CODE = 'USD'
--and (GLI.ENTERED_DR <> GLI.ACCOUNTED_DR
-- or GLI.ENTERED_CR <> GLI.ACCOUNTED_CR)
--and GLI.USER_JE_CATEGORY_NAME = 'Bill'
--and substr(SOB.SHORT_NAME,1,2) in ('HB')
--AND GLI.STATUS_DESCRIPTION IS NOT NULL
order by 3
--------------------------
GL INTERFACE DETAIL
Shows transactions level detail with full accounting and status information for each line in the GL interface across multiple sets of books
Can be used for SOX and system audits.
I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.
I have commented the SOB, Curreny condition etc. Check your Instances SOB short-name and for the currencies you want to run if it is needed
The following query is made to run for all the currenies and SOB's
SELECT SOB.SHORT_NAME "BOOK"
, GLI.SET_OF_BOOKS_ID "SOB ID"
, TRUNC(GLI.ACCOUNTING_DATE) "GL DATE"
, GLI.CURRENCY_CODE "CUR"
, GLI.USER_JE_CATEGORY_NAME "JE CATEGOTY"
, GLI.USER_JE_SOURCE_NAME "JE SOURCE"
, GLI.ENTERED_DR "ENT DR"
, GLI.ENTERED_CR "ENT CR"
, GLI.ACCOUNTED_DR "ACC DR"
, GLI.ACCOUNTED_CR "ACC CR"
, GLI.SEGMENT1||'.'||GLI.SEGMENT2||'.'||GLI.SEGMENT3||'.'||GLI.SEGMENT4||'.'||GLI.SEGMENT5
||'.'||GLI.SEGMENT6||'.'||GLI.SEGMENT7||'.'||GLI.SEGMENT8||'.'||GLI.SEGMENT9||'.'||GLI.SEGMENT10 "ACCOUNT COMB."
, GLI.REFERENCE1 "REF 1"
, GLI.REFERENCE2 "REF 2"
, GLI.REFERENCE4 "REF 4"
, GLI.REFERENCE7 "REF 7"
, GLI.REFERENCE10 "REF 10"
, GLI.WARNING_CODE
, GLI.STATUS_DESCRIPTION
, GLI.STATUS
FROM GL_INTERFACE GLI, GL_SETS_OF_BOOKS SOB
WHERE SOB.SET_OF_BOOKS_ID(+) = GLI.SET_OF_BOOKS_ID
--AND GLI.WARNING_CODE IS NOT NULL
--AND GLI.STATUS <> 'P'
and GLI.USER_JE_SOURCE_NAME = 'Payables'
and trunc(GLI.DATE_CREATED) > '01-JAN-2008'
--and GLI.CURRENCY_CODE = 'USD'
--and (GLI.ENTERED_DR <> GLI.ACCOUNTED_DR
-- or GLI.ENTERED_CR <> GLI.ACCOUNTED_CR)
--and GLI.USER_JE_CATEGORY_NAME = 'Bill'
--and substr(SOB.SHORT_NAME,1,2) in ('HB')
--AND GLI.STATUS_DESCRIPTION IS NOT NULL
order by 3
Saturday, August 2, 2008
FSG Report and Components Overview
GL : FSG Report and Components Overview:-
---------------------------------------------------
FSG REPORTS AND COMPONENTS OVERVIEW
Details definitions of FSG reports by component, and includes several small scripts for listing all components across different charts of accounts.
Can be used for SOX and system audits.
I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.
I have commented the SOB condition. Check your Instances SOB short-name and provide accordingly if you have multiple SOB in your business Structure.
-- FSG REPORTS --------------
SELECT FST.ID_FLEX_STRUCTURE_NAME
, R.NAME
, R.REPORT_TITLE
, R.DESCRIPTION
, R.COLUMN_SET"COLUMN SET"
, RW2.STRUCTURE_ID
, RW2.DESCRIPTION"COL DESC"
, R.ROW_SET"ROW SET"
, RW.DESCRIPTION"ROW DESC"
, R.REPORT_DISPLAY_SET"DISPLAY SET"
, R.CONTENT_SET"CONTENT SET"
, R.ROW_ORDER"ROW ORDER"
, R.ROUNDING_OPTION "RND"
, U.USER_NAME
, U.DESCRIPTION
, R.CREATION_DATE
FROM RG_REPORTS_V R, FND_ID_FLEX_STRUCTURES_V FST, FND_USER U, RG_REPORT_AXIS_SETS_V RW, RG_REPORT_AXIS_SETS_V RW2
WHERE R.STRUCTURE_ID = FST.ID_FLEX_NUM
AND R.ROW_SET_ID = RW.AXIS_SET_ID
AND R.COLUMN_SET_ID = RW2.AXIS_SET_ID
--AND SUBSTR(FST.ID_FLEX_STRUCTURE_NAME,1,2) IN (''HB')
AND R.CREATED_BY = U.USER_ID
ORDER BY 1, 2
-- FSG ROW SETS AND COLUMN SETS ----------------
SELECT FST.ID_FLEX_STRUCTURE_NAME "COA"
, DECODE(RW.AXIS_SET_TYPE,'R','ROW SET','C','COLUMN SET','##') "ROW/COLUMN"
, RW.NAME"SET NAME"
, RW.AXIS_SET_ID
FROM RG_REPORT_AXIS_SETS_V RW, FND_ID_FLEX_STRUCTURES_V FST
WHERE RW.STRUCTURE_ID = FST.ID_FLEX_NUM
--AND SUBSTR(FST.ID_FLEX_STRUCTURE_NAME,1,2) IN (''HB')
ORDER BY 1,2,3
---- CONTENT SETS ------------------------
SELECT FST.ID_FLEX_STRUCTURE_NAME "COA"
, CS.NAME
, CS.CONTENT_SET_ID
FROM RG_REPORT_CONTENT_SETS CS, FND_ID_FLEX_STRUCTURES_V FST
WHERE CS.STRUCTURE_ID = FST.ID_FLEX_NUM
--AND SUBSTR(FST.ID_FLEX_STRUCTURE_NAME,1,2) IN (''HB')
----- ROW ORDERS ---------------------------
SELECT FST.ID_FLEX_STRUCTURE_NAME "COA"
, RO.NAME "ROW ORDER"
, RO.DESCRIPTION "DESCRIPTION"
, RO.STRUCTURE_ID
, RO.ROW_ORDER_ID
FROM RG_ROW_ORDERS RO, FND_ID_FLEX_STRUCTURES_V FST
WHERE RO.STRUCTURE_ID = FST.ID_FLEX_NUM
--AND SUBSTR(FST.ID_FLEX_STRUCTURE_NAME,1,2) IN (''HB')
ORDER BY RO.NAME
---------------------------------------------------
FSG REPORTS AND COMPONENTS OVERVIEW
Details definitions of FSG reports by component, and includes several small scripts for listing all components across different charts of accounts.
Can be used for SOX and system audits.
I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.
I have commented the SOB condition. Check your Instances SOB short-name and provide accordingly if you have multiple SOB in your business Structure.
-- FSG REPORTS --------------
SELECT FST.ID_FLEX_STRUCTURE_NAME
, R.NAME
, R.REPORT_TITLE
, R.DESCRIPTION
, R.COLUMN_SET"COLUMN SET"
, RW2.STRUCTURE_ID
, RW2.DESCRIPTION"COL DESC"
, R.ROW_SET"ROW SET"
, RW.DESCRIPTION"ROW DESC"
, R.REPORT_DISPLAY_SET"DISPLAY SET"
, R.CONTENT_SET"CONTENT SET"
, R.ROW_ORDER"ROW ORDER"
, R.ROUNDING_OPTION "RND"
, U.USER_NAME
, U.DESCRIPTION
, R.CREATION_DATE
FROM RG_REPORTS_V R, FND_ID_FLEX_STRUCTURES_V FST, FND_USER U, RG_REPORT_AXIS_SETS_V RW, RG_REPORT_AXIS_SETS_V RW2
WHERE R.STRUCTURE_ID = FST.ID_FLEX_NUM
AND R.ROW_SET_ID = RW.AXIS_SET_ID
AND R.COLUMN_SET_ID = RW2.AXIS_SET_ID
--AND SUBSTR(FST.ID_FLEX_STRUCTURE_NAME,1,2) IN (''HB')
AND R.CREATED_BY = U.USER_ID
ORDER BY 1, 2
-- FSG ROW SETS AND COLUMN SETS ----------------
SELECT FST.ID_FLEX_STRUCTURE_NAME "COA"
, DECODE(RW.AXIS_SET_TYPE,'R','ROW SET','C','COLUMN SET','##') "ROW/COLUMN"
, RW.NAME"SET NAME"
, RW.AXIS_SET_ID
FROM RG_REPORT_AXIS_SETS_V RW, FND_ID_FLEX_STRUCTURES_V FST
WHERE RW.STRUCTURE_ID = FST.ID_FLEX_NUM
--AND SUBSTR(FST.ID_FLEX_STRUCTURE_NAME,1,2) IN (''HB')
ORDER BY 1,2,3
---- CONTENT SETS ------------------------
SELECT FST.ID_FLEX_STRUCTURE_NAME "COA"
, CS.NAME
, CS.CONTENT_SET_ID
FROM RG_REPORT_CONTENT_SETS CS, FND_ID_FLEX_STRUCTURES_V FST
WHERE CS.STRUCTURE_ID = FST.ID_FLEX_NUM
--AND SUBSTR(FST.ID_FLEX_STRUCTURE_NAME,1,2) IN (''HB')
----- ROW ORDERS ---------------------------
SELECT FST.ID_FLEX_STRUCTURE_NAME "COA"
, RO.NAME "ROW ORDER"
, RO.DESCRIPTION "DESCRIPTION"
, RO.STRUCTURE_ID
, RO.ROW_ORDER_ID
FROM RG_ROW_ORDERS RO, FND_ID_FLEX_STRUCTURES_V FST
WHERE RO.STRUCTURE_ID = FST.ID_FLEX_NUM
--AND SUBSTR(FST.ID_FLEX_STRUCTURE_NAME,1,2) IN (''HB')
ORDER BY RO.NAME
Flexfield Security Rule Definitions
GL : Flexfield Security Rule Definitions:-
----------------------------------------
FLEXFIELD SECURITY RULE DEFINITIONS
The following query will lists security rule definitions and GL account ranges.
I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.
SELECT A.APPLICATION_NAME "APPS",
FS.SEGMENT_NAME,
FVS.FLEX_VALUE_SET_NAME,
FVR.FLEX_VALUE_RULE_NAME,
FVR.PARENT_FLEX_VALUE_LOW "PRNT L",
FVR.PARENT_FLEX_VALUE_HIGH "PRNT H",
FVRL.INCLUDE_EXCLUDE_INDICATOR "INC/EXCL",
FVRL.FLEX_VALUE_LOW,
FVRL.FLEX_VALUE_HIGH
FROM FND_FLEX_VALUE_RULES FVR, FND_FLEX_VALUE_SETS FVS,
FND_FLEX_VALUE_RULE_LINES FVRL, FND_ID_FLEX_SEGMENTS FS, FND_APPLICATION_TL A
WHERE FVR.FLEX_VALUE_SET_ID = FVS.FLEX_VALUE_SET_ID
AND FVR.FLEX_VALUE_RULE_ID = FVRL.FLEX_VALUE_RULE_ID
AND FS.FLEX_VALUE_SET_ID = FVS.FLEX_VALUE_SET_ID
AND FS.APPLICATION_ID = A.APPLICATION_ID
ORDER BY A.APPLICATION_NAME ,FS.SEGMENT_NAME, FVS.FLEX_VALUE_SET_NAME,FVR.FLEX_VALUE_RULE_NAME,
FVR.PARENT_FLEX_VALUE_LOW ,FVR.PARENT_FLEX_VALUE_HIGH ,FVRL.FLEX_VALUE_LOW, FVRL.FLEX_VALUE_HIGH
Flexfield Security Rule Assignments
GL : Flexfield Security Rule Assignments:-
------------------------------------------------
FLEXFIELD SECURITY RULE ASSIGNMENTS TO RESPONSIBILITIES
The following query will lists security rule assignments to responsibilities
I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.
SELECT A.APPLICATION_NAME
, FVR.FLEX_VALUE_RULE_NAME
, R.RESPONSIBILITY_KEY
FROM FND_FLEX_VALUE_RULES FVR,
FND_FLEX_VALUE_RULE_USAGES RU, FND_RESPONSIBILITY R, FND_APPLICATION_TL A
WHERE FVR.FLEX_VALUE_RULE_ID = RU.FLEX_VALUE_RULE_ID
AND RU.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID
AND RU.APPLICATION_ID = A.APPLICATION_ID
AND FVR.FLEX_VALUE_RULE_NAME LIKE '%'
ORDER BY FLEX_VALUE_RULE_NAME
------------------------------------------------
FLEXFIELD SECURITY RULE ASSIGNMENTS TO RESPONSIBILITIES
The following query will lists security rule assignments to responsibilities
I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.
SELECT A.APPLICATION_NAME
, FVR.FLEX_VALUE_RULE_NAME
, R.RESPONSIBILITY_KEY
FROM FND_FLEX_VALUE_RULES FVR,
FND_FLEX_VALUE_RULE_USAGES RU, FND_RESPONSIBILITY R, FND_APPLICATION_TL A
WHERE FVR.FLEX_VALUE_RULE_ID = RU.FLEX_VALUE_RULE_ID
AND RU.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID
AND RU.APPLICATION_ID = A.APPLICATION_ID
AND FVR.FLEX_VALUE_RULE_NAME LIKE '%'
ORDER BY FLEX_VALUE_RULE_NAME
CVR Cross Validation Rule Overview
GL : CVR Cross Validation Rule Overview:-
-------------------------------------------------
CVR Overview (Cross Validation Rules )
Provides view of header level cross validation rule definitions to
obtain an overview of rules and messages across multiple charts of accounts
I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.
select fst.id_flex_structure_name"CoA"
, r.flex_validation_rule_name"Rule Name"
, r.enabled_flag"Enb?"
, r.ERROR_SEGMENT_COLUMN_NAME"Error Seg"
, length(tl.error_message_text)"Error Length"
, tl.ERROR_MESSAGE_TEXT"Message"
, tl.CREATION_DATE
FROM fnd_flex_validation_rules r,
fnd_flex_vdation_rules_tl tl,
fnd_id_flex_structures_vl fst
WHERE r.application_id = tl.application_id
AND fst.ID_FLEX_num = r.id_flex_num
AND r.id_flex_code = tl.id_flex_code
AND r.id_flex_num = tl.id_flex_num
AND r.flex_validation_rule_name = tl.flex_validation_rule_name
AND r.application_id = 101
--AND substr(fst.id_flex_structure_name,1,2) in ('BE','LU','ES') -- LIMITS RESULTS TO SPECIFIC CHARTS OF ACCOUNTS
--AND length(tl.error_message_text) > 150 --- THIS IS USED FOR CHECK FOR MESSAGES OVER 150 CHARACTERS THAT CAN CAUSE SQL ERRORS IN I-Expenses
ORDER BY 1,2
-------------------------------------------------
CVR Overview (Cross Validation Rules )
Provides view of header level cross validation rule definitions to
obtain an overview of rules and messages across multiple charts of accounts
I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.
select fst.id_flex_structure_name"CoA"
, r.flex_validation_rule_name"Rule Name"
, r.enabled_flag"Enb?"
, r.ERROR_SEGMENT_COLUMN_NAME"Error Seg"
, length(tl.error_message_text)"Error Length"
, tl.ERROR_MESSAGE_TEXT"Message"
, tl.CREATION_DATE
FROM fnd_flex_validation_rules r,
fnd_flex_vdation_rules_tl tl,
fnd_id_flex_structures_vl fst
WHERE r.application_id = tl.application_id
AND fst.ID_FLEX_num = r.id_flex_num
AND r.id_flex_code = tl.id_flex_code
AND r.id_flex_num = tl.id_flex_num
AND r.flex_validation_rule_name = tl.flex_validation_rule_name
AND r.application_id = 101
--AND substr(fst.id_flex_structure_name,1,2) in ('BE','LU','ES') -- LIMITS RESULTS TO SPECIFIC CHARTS OF ACCOUNTS
--AND length(tl.error_message_text) > 150 --- THIS IS USED FOR CHECK FOR MESSAGES OVER 150 CHARACTERS THAT CAN CAUSE SQL ERRORS IN I-Expenses
ORDER BY 1,2
CVR Cross Validation Rule Detail Listing
GL : CVR Cross Validation Rule Detail Listing:-
------------------------------------------------------
CVR CROSS VALIDATION RULE DETAIL LISTING
Provides detail view of CVR definition including account ranges.
I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.
SELECT FST.ID_FLEX_STRUCTURE_NAME
, R.FLEX_VALIDATION_RULE_NAME
, R.ENABLED_FLAG
, L.ENABLED_FLAG
, L.INCLUDE_EXCLUDE_INDICATOR"INC?"
, L.CONCATENATED_SEGMENTS_LOW "FROM"
, L.CONCATENATED_SEGMENTS_HIGH "TO"
, L.LAST_UPDATED_BY
, L.LAST_UPDATE_DATE
FROM FND_FLEX_VALIDATION_RULES R,
FND_FLEX_VDATION_RULES_TL TL,
FND_FLEX_VALIDATION_RULE_LINES L,
FND_ID_FLEX_STRUCTURES_VL FST
WHERE R.APPLICATION_ID = TL.APPLICATION_ID
AND FST.ID_FLEX_NUM = R.ID_FLEX_NUM
AND R.ID_FLEX_CODE = TL.ID_FLEX_CODE
AND R.ID_FLEX_NUM = TL.ID_FLEX_NUM
AND R.FLEX_VALIDATION_RULE_NAME = TL.FLEX_VALIDATION_RULE_NAME
AND R.FLEX_VALIDATION_RULE_NAME = TL.FLEX_VALIDATION_RULE_NAME
AND R.APPLICATION_ID = L.APPLICATION_ID
AND R.ID_FLEX_CODE = L.ID_FLEX_CODE
AND R.ID_FLEX_NUM = L.ID_FLEX_NUM
AND R.FLEX_VALIDATION_RULE_NAME = L.FLEX_VALIDATION_RULE_NAME
AND R.FLEX_VALIDATION_RULE_NAME = L.FLEX_VALIDATION_RULE_NAME
AND R.APPLICATION_ID = 101
ORDER BY 1,R.FLEX_VALIDATION_RULE_NAME, L.INCLUDE_EXCLUDE_INDICATOR DESC, L.CONCATENATED_SEGMENTS_LOW
------------------------------------------------------
CVR CROSS VALIDATION RULE DETAIL LISTING
Provides detail view of CVR definition including account ranges.
I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.
SELECT FST.ID_FLEX_STRUCTURE_NAME
, R.FLEX_VALIDATION_RULE_NAME
, R.ENABLED_FLAG
, L.ENABLED_FLAG
, L.INCLUDE_EXCLUDE_INDICATOR"INC?"
, L.CONCATENATED_SEGMENTS_LOW "FROM"
, L.CONCATENATED_SEGMENTS_HIGH "TO"
, L.LAST_UPDATED_BY
, L.LAST_UPDATE_DATE
FROM FND_FLEX_VALIDATION_RULES R,
FND_FLEX_VDATION_RULES_TL TL,
FND_FLEX_VALIDATION_RULE_LINES L,
FND_ID_FLEX_STRUCTURES_VL FST
WHERE R.APPLICATION_ID = TL.APPLICATION_ID
AND FST.ID_FLEX_NUM = R.ID_FLEX_NUM
AND R.ID_FLEX_CODE = TL.ID_FLEX_CODE
AND R.ID_FLEX_NUM = TL.ID_FLEX_NUM
AND R.FLEX_VALIDATION_RULE_NAME = TL.FLEX_VALIDATION_RULE_NAME
AND R.FLEX_VALIDATION_RULE_NAME = TL.FLEX_VALIDATION_RULE_NAME
AND R.APPLICATION_ID = L.APPLICATION_ID
AND R.ID_FLEX_CODE = L.ID_FLEX_CODE
AND R.ID_FLEX_NUM = L.ID_FLEX_NUM
AND R.FLEX_VALIDATION_RULE_NAME = L.FLEX_VALIDATION_RULE_NAME
AND R.FLEX_VALIDATION_RULE_NAME = L.FLEX_VALIDATION_RULE_NAME
AND R.APPLICATION_ID = 101
ORDER BY 1,R.FLEX_VALIDATION_RULE_NAME, L.INCLUDE_EXCLUDE_INDICATOR DESC, L.CONCATENATED_SEGMENTS_LOW
Subscribe to:
Posts (Atom)
