VIEW: APPS.CST_PAC_AEL_GL_WIP_V

Source

View Text - Preformatted

SELECT /*+ ORDERED */ clct.legal_entity, ccga.cost_group_id, ccg.cost_group, clct.cost_type_id, cct.cost_type, clct.primary_cost_method, ccg.organization_id, 706, cah.set_of_books_id, ood.organization_code, we.organization_id, lu4.meaning, 'WIP TRX', lu1.meaning, wt.transaction_type, to_char(wt.transaction_id), wt.transaction_id, TRUNC(wt.transaction_date), wt.reference, cah.acct_event_source_table, wt.transaction_id, lu2.meaning, to_char(cal.ae_line_type_code), cal.code_combination_id, cal.currency_code, cal.entered_dr, cal.entered_cr, cal.accounted_dr, cal.accounted_cr, cal.currency_conversion_date, cal.currency_conversion_type, glct.user_conversion_type, cal.currency_conversion_rate, cah.accounting_date, lu5.meaning, DECODE(NVL(cal.gl_sl_link_id,-1),-1,'N','Y'), cah.gl_transfer_run_id, cal.source_table, cal.source_id, 'CAL', cal.description, rpad(cal.description,132), wt.transaction_uom, wt.transaction_quantity, to_char(NVL(cal.accounted_dr,cal.accounted_cr)/wt.primary_quantity), wt.operation_seq_num, bd.department_code, bd.description, wt.resource_seq_num, poh.segment1, we.wip_entity_id, DECODE(wt.line_id, NULL, we.wip_entity_name, ''), wt.line_id, wl.line_code, msik.concatenated_segments, lu3.meaning, br.resource_id, br.resource_code, wfs.schedule_number, mtr.reason_name, cal.cost_element_id, cce.cost_element, jel.je_header_id, jel.je_line_num, cal.last_update_date, cal.last_updated_by, cal.creation_date, cal.created_by, cal.last_update_login, cal.request_id, cal.program_application_id, cal.program_id, cal.program_update_date FROM gl_je_lines jel, gl_je_headers jeh, gl_import_references R, gl_period_statuses gps, gl_daily_conversion_types glct, cst_ae_headers cah, cst_ae_lines cal , cst_cost_elements cce, cst_le_cost_types clct, cst_cost_groups ccg, cst_cost_types cct, cst_cost_group_assignments ccga, wip_transactions wt, wip_lines wl, wip_entities we, bom_resources br, wip_flow_schedules wfs, org_organization_definitions ood, po_headers poh, mtl_system_items_kfv msik, mtl_transaction_reasons mtr, bom_departments bd, mfg_lookups lu1, mfg_lookups lu2, mfg_lookups lu3, mfg_lookups lu4, mfg_lookups lu5 WHERE we.wip_entity_id = wt.wip_entity_id AND wl.line_id ( + ) = wt.line_id AND we.organization_id = wt.organization_id AND bd.department_id ( + ) = wt.department_id AND mtr.reason_id ( + ) = wt.reason_id AND poh.po_header_id ( + ) = wt.po_header_id AND cce.cost_element_id ( + ) = cal.cost_element_id AND br.resource_id ( + ) = cal.resource_id AND wfs.wip_entity_id ( + ) = we.wip_entity_id AND lu1.lookup_type ( + ) = 'WIP_TRANSACTION_TYPE' AND lu1.lookup_code ( + ) = wt.transaction_type AND lu2.lookup_type = 'CST_ACCOUNTING_LINE_TYPE' AND lu2.lookup_code = to_number ( cal.ae_line_type_code ) AND lu3.lookup_code ( + ) = cal.basis_type AND lu3.lookup_type ( + ) = 'CST_BASIS' AND lu4.lookup_code = 2 AND lu4.lookup_type = 'CST_VIEW_ACCOUNTING' AND lu5.lookup_type = 'SYS_YES_NO' AND lu5.lookup_code = decode ( NVL ( cah.gl_transfer_run_id, -1 ) , -1, 2, 1 ) AND gps.application_id = 401 AND gps.period_name = jeh.period_name AND wt.transaction_date BETWEEN gps.start_date AND gps.end_date AND wt.currency_conversion_type = glct.conversion_type ( + ) AND wt.organization_id = ood.organization_id AND jel.je_header_id = jeh.je_header_id AND R.je_header_id = jeh.je_header_id AND R.je_line_num = jel.je_line_num AND R.gl_sl_link_id is not null AND R.reference_3 is not null AND cah.gl_transfer_run_id = R.reference_1 AND cal.reference3 = R.reference_3 AND cal.code_combination_id = jel.code_combination_id AND cal.GL_SL_LINK_ID = R.gl_sl_link_id AND jeh.je_source = 'Periodic Inventory' AND jeh.je_category = 'WIP' AND ccga.organization_id = wt.organization_id AND ccg.cost_group_id = ccga.cost_group_id AND ccg.cost_group_type = 2 AND clct.legal_entity = ccg.legal_entity AND cah.accounting_event_id = wt.transaction_id AND cah.acct_event_source_table = 'WT' AND cal.ae_header_id = cah.ae_header_id AND cct.cost_type_id = clct.cost_type_id AND cah.cost_type_id = clct.cost_type_id AND cah.cost_group_id = ccga.cost_group_id AND cah.legal_entity_id = ccg.legal_entity AND msik.organization_id(+) = we.organization_id AND msik.inventory_item_id(+) = we.primary_item_id AND gps.set_of_books_id = clct.set_of_books_id AND clct.set_of_books_id = jel.ledger_id UNION ALL SELECT /*+ ORDERED */ clct.legal_entity, ccga.cost_group_id, ccg.cost_group, clct.cost_type_id, cct.cost_type, clct.primary_cost_method, ccg.organization_id, 706, cah.set_of_books_id, ood.organization_code, cah.organization_id, lu4.meaning, 'WIP TRX', lu1.meaning, wt.transaction_type, to_char ( wt.transaction_id ) , wt.transaction_id, TRUNC ( wt.transaction_date ) , wt.reference, cah.acct_event_source_table, wt.transaction_id, lu2.meaning, cal.ae_line_type_code, cal.code_combination_id, cal.currency_code, cal.entered_dr, cal.entered_cr, cal.accounted_dr, cal.accounted_cr, cal.currency_conversion_date, cal.currency_conversion_type, glct.user_conversion_type , cal.currency_conversion_rate, cah.accounting_date, lu5.meaning, DECODE ( NVL ( cal.gl_sl_link_id, -1 ) , -1,'N', 'Y' ) , cah.gl_transfer_run_id, cal.source_table, cal.source_id, 'CAL', cal.description, rpad ( cal.description, 132 ) , wt.transaction_uom, wt.transaction_quantity, to_char ( NVL ( cal.accounted_dr,cal.accounted_cr) /wt.primary_quantity ) , wt.operation_seq_num, bd.department_code, bd.description, wt.resource_seq_num, poh.segment1, we.wip_entity_id, DECODE ( wt.line_id, NULL, we.wip_entity_name, '' ) , wt.line_id, wl.line_code, msik.concatenated_segments, lu3.meaning , br.resource_id, br.resource_code, wfs.schedule_number, mtr.reason_name, cal.cost_element_id, cce.cost_element, jel.je_header_id, jel.je_line_num, cal.last_update_date, cal.last_updated_by, cal.creation_date, cal.created_by, cal.last_update_login, cal.request_id, cal.program_application_id, cal.program_id, cal.program_update_date FROM gl_je_lines jel, gl_je_headers jeh, gl_import_references R, gl_period_statuses gps, gl_daily_conversion_types glct, cst_ae_headers cah, cst_ae_lines cal , cst_cost_elements cce, cst_le_cost_types clct, cst_cost_groups ccg, cst_cost_types cct, cst_cost_group_assignments ccga, wip_transactions wt, wip_lines wl, wip_entities we, bom_resources br, wip_flow_schedules wfs, org_organization_definitions ood, po_headers poh, mtl_system_items_kfv msik, mtl_transaction_reasons mtr, bom_departments bd, mfg_lookups lu1, mfg_lookups lu2, mfg_lookups lu3, mfg_lookups lu4, mfg_lookups lu5 WHERE we.wip_entity_id = wt.wip_entity_id AND wl.line_id ( + ) = wt.line_id AND we.organization_id = wt.organization_id AND bd.department_id ( + ) = wt.department_id AND mtr.reason_id ( + ) = wt.reason_id AND poh.po_header_id ( + ) = wt.po_header_id AND cce.cost_element_id ( + ) = cal.cost_element_id AND br.resource_id ( + ) = cal.resource_id AND wfs.wip_entity_id ( + ) = we.wip_entity_id AND lu1.lookup_type ( + ) = 'WIP_TRANSACTION_TYPE' AND lu1.lookup_code ( + ) = wt.transaction_type AND lu2.lookup_type = 'CST_ACCOUNTING_LINE_TYPE' AND lu2.lookup_code = to_number ( cal.ae_line_type_code ) AND lu3.lookup_code ( + ) = cal.basis_type AND lu3.lookup_type ( + ) = 'CST_BASIS' AND lu4.lookup_code = 2 AND lu4.lookup_type = 'CST_VIEW_ACCOUNTING' AND lu5.lookup_type = 'SYS_YES_NO' AND lu5.lookup_code = decode ( NVL ( cah.gl_transfer_run_id,-1) , -1, 2, 1 ) AND gps.application_id = 401 AND gps.period_name = jeh.period_name AND wt.transaction_date BETWEEN gps.start_date AND gps.end_date AND wt.currency_conversion_type = glct.conversion_type ( + ) AND wt.organization_id = ood.organization_id AND jel.je_header_id = jeh.je_header_id AND R.je_header_id = jeh.je_header_id AND R.je_line_num = jel.je_line_num AND cah.gl_transfer_run_id = R.reference_1 AND R.gl_sl_link_id is null AND R.reference_3 is null AND cal.code_combination_id = jel.code_combination_id AND cal.currency_code = jeh.currency_code AND jeh.je_source = 'Periodic Inventory' AND jeh.je_category = 'WIP' AND ccga.organization_id = wt.organization_id AND ccg.cost_group_id = ccga.cost_group_id AND ccg.cost_group_type = 2 AND clct.legal_entity = ccg.legal_entity AND cct.cost_type_id = clct.cost_type_id AND cah.accounting_event_id = wt.transaction_id AND cah.acct_event_source_table = 'WT' AND cal.ae_header_id = cah.ae_header_id AND cah.cost_type_id = clct.cost_type_id AND cah.cost_group_id = ccga.cost_group_id AND cah.legal_entity_id = ccg.legal_entity AND msik.inventory_item_id(+) = we.primary_item_id AND msik.organization_id(+) = we.organization_id AND gps.set_of_books_id = clct.set_of_books_id AND clct.set_of_books_id = jel.ledger_id

View Text - HTML Formatted

SELECT /*+ ORDERED */ CLCT.LEGAL_ENTITY
, CCGA.COST_GROUP_ID
, CCG.COST_GROUP
, CLCT.COST_TYPE_ID
, CCT.COST_TYPE
, CLCT.PRIMARY_COST_METHOD
, CCG.ORGANIZATION_ID
, 706
, CAH.SET_OF_BOOKS_ID
, OOD.ORGANIZATION_CODE
, WE.ORGANIZATION_ID
, LU4.MEANING
, 'WIP TRX'
, LU1.MEANING
, WT.TRANSACTION_TYPE
, TO_CHAR(WT.TRANSACTION_ID)
, WT.TRANSACTION_ID
, TRUNC(WT.TRANSACTION_DATE)
, WT.REFERENCE
, CAH.ACCT_EVENT_SOURCE_TABLE
, WT.TRANSACTION_ID
, LU2.MEANING
, TO_CHAR(CAL.AE_LINE_TYPE_CODE)
, CAL.CODE_COMBINATION_ID
, CAL.CURRENCY_CODE
, CAL.ENTERED_DR
, CAL.ENTERED_CR
, CAL.ACCOUNTED_DR
, CAL.ACCOUNTED_CR
, CAL.CURRENCY_CONVERSION_DATE
, CAL.CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE
, CAL.CURRENCY_CONVERSION_RATE
, CAH.ACCOUNTING_DATE
, LU5.MEANING
, DECODE(NVL(CAL.GL_SL_LINK_ID
, -1)
, -1
, 'N'
, 'Y')
, CAH.GL_TRANSFER_RUN_ID
, CAL.SOURCE_TABLE
, CAL.SOURCE_ID
, 'CAL'
, CAL.DESCRIPTION
, RPAD(CAL.DESCRIPTION
, 132)
, WT.TRANSACTION_UOM
, WT.TRANSACTION_QUANTITY
, TO_CHAR(NVL(CAL.ACCOUNTED_DR
, CAL.ACCOUNTED_CR)/WT.PRIMARY_QUANTITY)
, WT.OPERATION_SEQ_NUM
, BD.DEPARTMENT_CODE
, BD.DESCRIPTION
, WT.RESOURCE_SEQ_NUM
, POH.SEGMENT1
, WE.WIP_ENTITY_ID
, DECODE(WT.LINE_ID
, NULL
, WE.WIP_ENTITY_NAME
, '')
, WT.LINE_ID
, WL.LINE_CODE
, MSIK.CONCATENATED_SEGMENTS
, LU3.MEANING
, BR.RESOURCE_ID
, BR.RESOURCE_CODE
, WFS.SCHEDULE_NUMBER
, MTR.REASON_NAME
, CAL.COST_ELEMENT_ID
, CCE.COST_ELEMENT
, JEL.JE_HEADER_ID
, JEL.JE_LINE_NUM
, CAL.LAST_UPDATE_DATE
, CAL.LAST_UPDATED_BY
, CAL.CREATION_DATE
, CAL.CREATED_BY
, CAL.LAST_UPDATE_LOGIN
, CAL.REQUEST_ID
, CAL.PROGRAM_APPLICATION_ID
, CAL.PROGRAM_ID
, CAL.PROGRAM_UPDATE_DATE
FROM GL_JE_LINES JEL
, GL_JE_HEADERS JEH
, GL_IMPORT_REFERENCES R
, GL_PERIOD_STATUSES GPS
, GL_DAILY_CONVERSION_TYPES GLCT
, CST_AE_HEADERS CAH
, CST_AE_LINES CAL
, CST_COST_ELEMENTS CCE
, CST_LE_COST_TYPES CLCT
, CST_COST_GROUPS CCG
, CST_COST_TYPES CCT
, CST_COST_GROUP_ASSIGNMENTS CCGA
, WIP_TRANSACTIONS WT
, WIP_LINES WL
, WIP_ENTITIES WE
, BOM_RESOURCES BR
, WIP_FLOW_SCHEDULES WFS
, ORG_ORGANIZATION_DEFINITIONS OOD
, PO_HEADERS POH
, MTL_SYSTEM_ITEMS_KFV MSIK
, MTL_TRANSACTION_REASONS MTR
, BOM_DEPARTMENTS BD
, MFG_LOOKUPS LU1
, MFG_LOOKUPS LU2
, MFG_LOOKUPS LU3
, MFG_LOOKUPS LU4
, MFG_LOOKUPS LU5
WHERE WE.WIP_ENTITY_ID = WT.WIP_ENTITY_ID
AND WL.LINE_ID ( + ) = WT.LINE_ID
AND WE.ORGANIZATION_ID = WT.ORGANIZATION_ID
AND BD.DEPARTMENT_ID ( + ) = WT.DEPARTMENT_ID
AND MTR.REASON_ID ( + ) = WT.REASON_ID
AND POH.PO_HEADER_ID ( + ) = WT.PO_HEADER_ID
AND CCE.COST_ELEMENT_ID ( + ) = CAL.COST_ELEMENT_ID
AND BR.RESOURCE_ID ( + ) = CAL.RESOURCE_ID
AND WFS.WIP_ENTITY_ID ( + ) = WE.WIP_ENTITY_ID
AND LU1.LOOKUP_TYPE ( + ) = 'WIP_TRANSACTION_TYPE'
AND LU1.LOOKUP_CODE ( + ) = WT.TRANSACTION_TYPE
AND LU2.LOOKUP_TYPE = 'CST_ACCOUNTING_LINE_TYPE'
AND LU2.LOOKUP_CODE = TO_NUMBER ( CAL.AE_LINE_TYPE_CODE )
AND LU3.LOOKUP_CODE ( + ) = CAL.BASIS_TYPE
AND LU3.LOOKUP_TYPE ( + ) = 'CST_BASIS'
AND LU4.LOOKUP_CODE = 2
AND LU4.LOOKUP_TYPE = 'CST_VIEW_ACCOUNTING'
AND LU5.LOOKUP_TYPE = 'SYS_YES_NO'
AND LU5.LOOKUP_CODE = DECODE ( NVL ( CAH.GL_TRANSFER_RUN_ID
, -1 )
, -1
, 2
, 1 )
AND GPS.APPLICATION_ID = 401
AND GPS.PERIOD_NAME = JEH.PERIOD_NAME
AND WT.TRANSACTION_DATE BETWEEN GPS.START_DATE
AND GPS.END_DATE
AND WT.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE ( + )
AND WT.ORGANIZATION_ID = OOD.ORGANIZATION_ID
AND JEL.JE_HEADER_ID = JEH.JE_HEADER_ID
AND R.JE_HEADER_ID = JEH.JE_HEADER_ID
AND R.JE_LINE_NUM = JEL.JE_LINE_NUM
AND R.GL_SL_LINK_ID IS NOT NULL
AND R.REFERENCE_3 IS NOT NULL
AND CAH.GL_TRANSFER_RUN_ID = R.REFERENCE_1
AND CAL.REFERENCE3 = R.REFERENCE_3
AND CAL.CODE_COMBINATION_ID = JEL.CODE_COMBINATION_ID
AND CAL.GL_SL_LINK_ID = R.GL_SL_LINK_ID
AND JEH.JE_SOURCE = 'PERIODIC INVENTORY'
AND JEH.JE_CATEGORY = 'WIP'
AND CCGA.ORGANIZATION_ID = WT.ORGANIZATION_ID
AND CCG.COST_GROUP_ID = CCGA.COST_GROUP_ID
AND CCG.COST_GROUP_TYPE = 2
AND CLCT.LEGAL_ENTITY = CCG.LEGAL_ENTITY
AND CAH.ACCOUNTING_EVENT_ID = WT.TRANSACTION_ID
AND CAH.ACCT_EVENT_SOURCE_TABLE = 'WT'
AND CAL.AE_HEADER_ID = CAH.AE_HEADER_ID
AND CCT.COST_TYPE_ID = CLCT.COST_TYPE_ID
AND CAH.COST_TYPE_ID = CLCT.COST_TYPE_ID
AND CAH.COST_GROUP_ID = CCGA.COST_GROUP_ID
AND CAH.LEGAL_ENTITY_ID = CCG.LEGAL_ENTITY
AND MSIK.ORGANIZATION_ID(+) = WE.ORGANIZATION_ID
AND MSIK.INVENTORY_ITEM_ID(+) = WE.PRIMARY_ITEM_ID
AND GPS.SET_OF_BOOKS_ID = CLCT.SET_OF_BOOKS_ID
AND CLCT.SET_OF_BOOKS_ID = JEL.LEDGER_ID UNION ALL SELECT /*+ ORDERED */ CLCT.LEGAL_ENTITY
, CCGA.COST_GROUP_ID
, CCG.COST_GROUP
, CLCT.COST_TYPE_ID
, CCT.COST_TYPE
, CLCT.PRIMARY_COST_METHOD
, CCG.ORGANIZATION_ID
, 706
, CAH.SET_OF_BOOKS_ID
, OOD.ORGANIZATION_CODE
, CAH.ORGANIZATION_ID
, LU4.MEANING
, 'WIP TRX'
, LU1.MEANING
, WT.TRANSACTION_TYPE
, TO_CHAR ( WT.TRANSACTION_ID )
, WT.TRANSACTION_ID
, TRUNC ( WT.TRANSACTION_DATE )
, WT.REFERENCE
, CAH.ACCT_EVENT_SOURCE_TABLE
, WT.TRANSACTION_ID
, LU2.MEANING
, CAL.AE_LINE_TYPE_CODE
, CAL.CODE_COMBINATION_ID
, CAL.CURRENCY_CODE
, CAL.ENTERED_DR
, CAL.ENTERED_CR
, CAL.ACCOUNTED_DR
, CAL.ACCOUNTED_CR
, CAL.CURRENCY_CONVERSION_DATE
, CAL.CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE
, CAL.CURRENCY_CONVERSION_RATE
, CAH.ACCOUNTING_DATE
, LU5.MEANING
, DECODE ( NVL ( CAL.GL_SL_LINK_ID
, -1 )
, -1
, 'N'
, 'Y' )
, CAH.GL_TRANSFER_RUN_ID
, CAL.SOURCE_TABLE
, CAL.SOURCE_ID
, 'CAL'
, CAL.DESCRIPTION
, RPAD ( CAL.DESCRIPTION
, 132 )
, WT.TRANSACTION_UOM
, WT.TRANSACTION_QUANTITY
, TO_CHAR ( NVL ( CAL.ACCOUNTED_DR
, CAL.ACCOUNTED_CR) /WT.PRIMARY_QUANTITY )
, WT.OPERATION_SEQ_NUM
, BD.DEPARTMENT_CODE
, BD.DESCRIPTION
, WT.RESOURCE_SEQ_NUM
, POH.SEGMENT1
, WE.WIP_ENTITY_ID
, DECODE ( WT.LINE_ID
, NULL
, WE.WIP_ENTITY_NAME
, '' )
, WT.LINE_ID
, WL.LINE_CODE
, MSIK.CONCATENATED_SEGMENTS
, LU3.MEANING
, BR.RESOURCE_ID
, BR.RESOURCE_CODE
, WFS.SCHEDULE_NUMBER
, MTR.REASON_NAME
, CAL.COST_ELEMENT_ID
, CCE.COST_ELEMENT
, JEL.JE_HEADER_ID
, JEL.JE_LINE_NUM
, CAL.LAST_UPDATE_DATE
, CAL.LAST_UPDATED_BY
, CAL.CREATION_DATE
, CAL.CREATED_BY
, CAL.LAST_UPDATE_LOGIN
, CAL.REQUEST_ID
, CAL.PROGRAM_APPLICATION_ID
, CAL.PROGRAM_ID
, CAL.PROGRAM_UPDATE_DATE
FROM GL_JE_LINES JEL
, GL_JE_HEADERS JEH
, GL_IMPORT_REFERENCES R
, GL_PERIOD_STATUSES GPS
, GL_DAILY_CONVERSION_TYPES GLCT
, CST_AE_HEADERS CAH
, CST_AE_LINES CAL
, CST_COST_ELEMENTS CCE
, CST_LE_COST_TYPES CLCT
, CST_COST_GROUPS CCG
, CST_COST_TYPES CCT
, CST_COST_GROUP_ASSIGNMENTS CCGA
, WIP_TRANSACTIONS WT
, WIP_LINES WL
, WIP_ENTITIES WE
, BOM_RESOURCES BR
, WIP_FLOW_SCHEDULES WFS
, ORG_ORGANIZATION_DEFINITIONS OOD
, PO_HEADERS POH
, MTL_SYSTEM_ITEMS_KFV MSIK
, MTL_TRANSACTION_REASONS MTR
, BOM_DEPARTMENTS BD
, MFG_LOOKUPS LU1
, MFG_LOOKUPS LU2
, MFG_LOOKUPS LU3
, MFG_LOOKUPS LU4
, MFG_LOOKUPS LU5
WHERE WE.WIP_ENTITY_ID = WT.WIP_ENTITY_ID
AND WL.LINE_ID ( + ) = WT.LINE_ID
AND WE.ORGANIZATION_ID = WT.ORGANIZATION_ID
AND BD.DEPARTMENT_ID ( + ) = WT.DEPARTMENT_ID
AND MTR.REASON_ID ( + ) = WT.REASON_ID
AND POH.PO_HEADER_ID ( + ) = WT.PO_HEADER_ID
AND CCE.COST_ELEMENT_ID ( + ) = CAL.COST_ELEMENT_ID
AND BR.RESOURCE_ID ( + ) = CAL.RESOURCE_ID
AND WFS.WIP_ENTITY_ID ( + ) = WE.WIP_ENTITY_ID
AND LU1.LOOKUP_TYPE ( + ) = 'WIP_TRANSACTION_TYPE'
AND LU1.LOOKUP_CODE ( + ) = WT.TRANSACTION_TYPE
AND LU2.LOOKUP_TYPE = 'CST_ACCOUNTING_LINE_TYPE'
AND LU2.LOOKUP_CODE = TO_NUMBER ( CAL.AE_LINE_TYPE_CODE )
AND LU3.LOOKUP_CODE ( + ) = CAL.BASIS_TYPE
AND LU3.LOOKUP_TYPE ( + ) = 'CST_BASIS'
AND LU4.LOOKUP_CODE = 2
AND LU4.LOOKUP_TYPE = 'CST_VIEW_ACCOUNTING'
AND LU5.LOOKUP_TYPE = 'SYS_YES_NO'
AND LU5.LOOKUP_CODE = DECODE ( NVL ( CAH.GL_TRANSFER_RUN_ID
, -1)
, -1
, 2
, 1 )
AND GPS.APPLICATION_ID = 401
AND GPS.PERIOD_NAME = JEH.PERIOD_NAME
AND WT.TRANSACTION_DATE BETWEEN GPS.START_DATE
AND GPS.END_DATE
AND WT.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE ( + )
AND WT.ORGANIZATION_ID = OOD.ORGANIZATION_ID
AND JEL.JE_HEADER_ID = JEH.JE_HEADER_ID
AND R.JE_HEADER_ID = JEH.JE_HEADER_ID
AND R.JE_LINE_NUM = JEL.JE_LINE_NUM
AND CAH.GL_TRANSFER_RUN_ID = R.REFERENCE_1
AND R.GL_SL_LINK_ID IS NULL
AND R.REFERENCE_3 IS NULL
AND CAL.CODE_COMBINATION_ID = JEL.CODE_COMBINATION_ID
AND CAL.CURRENCY_CODE = JEH.CURRENCY_CODE
AND JEH.JE_SOURCE = 'PERIODIC INVENTORY'
AND JEH.JE_CATEGORY = 'WIP'
AND CCGA.ORGANIZATION_ID = WT.ORGANIZATION_ID
AND CCG.COST_GROUP_ID = CCGA.COST_GROUP_ID
AND CCG.COST_GROUP_TYPE = 2
AND CLCT.LEGAL_ENTITY = CCG.LEGAL_ENTITY
AND CCT.COST_TYPE_ID = CLCT.COST_TYPE_ID
AND CAH.ACCOUNTING_EVENT_ID = WT.TRANSACTION_ID
AND CAH.ACCT_EVENT_SOURCE_TABLE = 'WT'
AND CAL.AE_HEADER_ID = CAH.AE_HEADER_ID
AND CAH.COST_TYPE_ID = CLCT.COST_TYPE_ID
AND CAH.COST_GROUP_ID = CCGA.COST_GROUP_ID
AND CAH.LEGAL_ENTITY_ID = CCG.LEGAL_ENTITY
AND MSIK.INVENTORY_ITEM_ID(+) = WE.PRIMARY_ITEM_ID
AND MSIK.ORGANIZATION_ID(+) = WE.ORGANIZATION_ID
AND GPS.SET_OF_BOOKS_ID = CLCT.SET_OF_BOOKS_ID
AND CLCT.SET_OF_BOOKS_ID = JEL.LEDGER_ID