Hi Experts,
We have seen a view in our account which is as below (Created by other resource long back)
select /*+ use_merge(sub,seg1) PARALLEL(sub) */
sub.“CATEGORY”,sub.“JE_BATCH_NAME”,sub.“JE_HEADER_DESCRIPTION”,sub.“JE_HEADER_NAME”,sub.“JE_LINE_DESCRIPTION”,sub.“DESCRIPTION”,sub.“NAME”,sub.“LOCATION”,sub.“TRANSACTION_NUMBER”,sub.“TRANSACTION_DATE”,sub.“DIST_LINE_NUMBER”,sub.“PO_NUMBER”,sub.“PAYMENT_NUMBER”,sub.“SALES_ORDER”,sub.“INVOICE_PAYMENT_STATUS”,sub.“CURRENCY_CODE”,sub.“EXCHANGE_RATE”,sub.“JE_ACCOUNTED_DR”,sub.“JE_ACCOUNTED_CR”,sub.“AMOUNT”,sub.“STATUS”,sub.“FISCAL_PERIOD”,sub.“FISCAL_YEAR”,sub.“PERIOD_NAME”,sub.“EFFECTIVE_DATE”,sub.“JE_SOURCE”,sub.“JE_CATEGORY”,sub.“TRANSACTION_TYPE”,sub.“DOCUMENT_NAME”,sub.“GL_ACCOUNT”,sub.“COMPANY”,sub.“DEPARTMENT”,sub.“ACCOUNT”,sub.“PROJECT”,sub.“PRODUCT”,sub.“CUSTOMER”,sub.“GL_DISTRIBUTION_DATE”,sub.“POSTED_DATE”,sub.“LAST_BUILD_DATE”,sub.“JE_BATCH_ID”,sub.“JE_HEADER_ID”,sub.“JE_LINE_NUM”,sub.“CODE_COMBINATION_ID”,sub.“AP_INVOICE_ID”,sub.“INVOICE_DISTRIBUTION_ID”,sub.“CUSTOMER_TRX_ID”,sub.“CUSTOMER_TRX_LINE_ID”,sub.“PO_HEADER_ID”,sub.“PO_LINE_ID”,sub.“ROW_ID”,
seg1.description Company_Desc,
seg2.description Department_Desc,
seg3.description Account_Desc,
seg4.description Project_Desc,
seg5.description Product_Desc
from
apps.xx_fnd_flex_desc_v seg1,
apps.xx_fnd_flex_desc_v seg2,
apps.xx_fnd_flex_desc_v seg3,
apps.xx_fnd_flex_desc_v seg4,
apps.xx_fnd_flex_desc_v seg5,
apps.xx_gl_subledger_mv sub
where
sub.company = seg1.flex_value
and seg1.flex_value_set_id = 1003775
and sub.department = seg2.flex_value
and seg2.flex_value_set_id = 1003774
and sub.account = seg3.flex_value
and seg3.flex_value_set_id = 1002347
and sub.project = seg4.flex_value
and seg4.flex_value_set_id = 1002348
AND SUB.PRODUCT = SEG5.FLEX_VALUE
and seg5.flex_value_set_id = 1002349
But, I am not sure how this hint works. Can anyone please help me on how this hint works. I googled, but I didn’t understood
Thanks in Advance