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.

VIEW: APPS.CST_AEL_GL_WIP_V

Source

View Text - Preformatted


SELECT /*+ ORDERED */ 706, ood.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, 'WT', wt.transaction_id, lu2.meaning, to_char(wta.accounting_line_type), wta.reference_account, nvl(wt.currency_code,nvl(wta.currency_code, sob.currency_code)), DECODE(sign(nvl(wta.transaction_value,wta.base_transaction_value)), 1,nvl(wta.transaction_value,wta.base_transaction_value), 0,0,NULL), DECODE(sign(nvl(wta.transaction_value,wta.base_transaction_value)), -1,(-1*nvl(wta.transaction_value,wta.base_transaction_value)), NULL), DECODE(sign(wta.base_transaction_value), 1,wta.base_transaction_value, 0,0,NULL), DECODE(sign(wta.base_transaction_value), -1,(-1*wta.base_transaction_value), NULL), wt.currency_conversion_date, wt.currency_conversion_type, glct.user_conversion_type, wt.currency_conversion_rate, TRUNC(wt.transaction_date), lu5.meaning, DECODE(wta.gl_batch_id,-1,'N','Y'), DECODE(wta.gl_batch_id,-1,to_number(null),wta.gl_batch_id), 'WT', wt.transaction_id, 'WTA', decode(cce.cost_element, NULL,lu2.meaning,lu2.meaning||', '||cce.cost_element), rpad(decode(cce.cost_element, NULL,lu2.meaning,lu2.meaning||', '||cce.cost_element),132), wt.transaction_uom, wt.transaction_quantity, DECODE(wta.primary_quantity, NULL,NULL, 0,NULL, ABS(wta.base_transaction_value/wta.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, wta.cost_element_id, cce.cost_element, jel.je_header_id, jel.je_line_num, wta.last_update_date, wta.last_updated_by, wta.creation_date, wta.created_by, wta.last_update_login, wta.request_id, wta.program_application_id, wta.program_id, wta.program_update_date FROM gl_je_lines jel, gl_je_headers jeh, gl_import_references R, gl_period_statuses gps, gl_sets_of_books sob, gl_daily_conversion_types glct, wip_transaction_accounts wta, wip_transactions wt, wip_entities we, wip_lines wl, cst_cost_elements cce, wip_flow_schedules wfs, po_headers poh, bom_resources br, mtl_transaction_reasons mtr, bom_departments bd, org_organization_definitions ood, mtl_system_items_kfv msik, mfg_lookups lu1, mfg_lookups lu2, mfg_lookups lu3, mfg_lookups lu4, mfg_lookups lu5 WHERE wta.transaction_id = wt.transaction_id AND 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(+) = wta.cost_element_id AND br.resource_id(+) = wta.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 = wta.accounting_line_type AND lu3.lookup_code(+) = wta.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(wta.gl_batch_id, -1, 2, 1) AND sob.set_of_books_id = ood.set_of_books_id AND gps.application_id = 401 AND gps.set_of_books_id = ood.set_of_books_id AND gps.period_name = jeh.period_name /* AND wta.transaction_date BETWEEN gps.start_date AND (trunc(gps.end_date)+0.99999) */ 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 sob.set_of_books_id = jel.ledger_id AND R.gl_sl_link_id IS NOT NULL AND R.reference_3 IS NOT NULL AND wta.gl_batch_id = R.reference_1 AND wta.transaction_id = R.reference_3 AND wta.reference_account = jel.code_combination_id AND wta.GL_SL_LINK_ID = R.gl_sl_link_id AND jeh.je_source = 'Inventory' AND jeh.je_category = 'WIP' AND msik.inventory_item_id(+) = we.primary_item_id AND msik.organization_id(+) = we.organization_id UNION ALL SELECT /*+ ORDERED */ 706, ood.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, 'WT', wt.transaction_id, lu2.meaning, to_char(wta.accounting_line_type), wta.reference_account, nvl(wt.currency_code,nvl(wta.currency_code, sob.currency_code)), DECODE(sign(nvl(wta.transaction_value,wta.base_transaction_value)), 1,nvl(wta.transaction_value,wta.base_transaction_value), 0,0,NULL), DECODE(sign(nvl(wta.transaction_value,wta.base_transaction_value)), -1,(-1*nvl(wta.transaction_value,wta.base_transaction_value)), NULL), DECODE(sign(wta.base_transaction_value), 1,wta.base_transaction_value, 0,0,NULL), DECODE(sign(wta.base_transaction_value), -1,(-1*wta.base_transaction_value), NULL), wt.currency_conversion_date, wt.currency_conversion_type, glct.user_conversion_type, wt.currency_conversion_rate, TRUNC(wt.transaction_date), lu5.meaning, DECODE(wta.gl_batch_id,-1,'N','Y'), DECODE(wta.gl_batch_id,-1,to_number(null),wta.gl_batch_id), 'WT', wt.transaction_id, 'WTA', lu2.meaning ||':'||cce.cost_element, rpad(cce.cost_element,80), /* ---------------------------Product Specific Columns ------------------------*/ wt.transaction_uom, wt.transaction_quantity, DECODE(wta.primary_quantity, NULL,NULL, 0,NULL, ABS(wta.base_transaction_value/wta.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, wta.cost_element_id, cce.cost_element, jel.je_header_id, jel.je_line_num, wta.last_update_date, wta.last_updated_by, wta.creation_date, wta.created_by, wta.last_update_login, wta.request_id, wta.program_application_id, wta.program_id, wta.program_update_date FROM gl_je_lines jel, gl_je_headers jeh, gl_import_references R, gl_period_statuses gps, gl_sets_of_books sob, gl_daily_conversion_types glct, wip_transaction_accounts wta, wip_transactions wt, wip_entities we, wip_lines wl, cst_cost_elements cce, wip_flow_schedules wfs, po_headers poh, bom_resources br, mtl_transaction_reasons mtr, bom_departments bd, org_organization_definitions ood, mtl_system_items_kfv msik, mfg_lookups lu1, mfg_lookups lu2, mfg_lookups lu3, mfg_lookups lu4, mfg_lookups lu5 WHERE wta.transaction_id = wt.transaction_id AND 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(+) = wta.cost_element_id AND br.resource_id(+) = wta.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 = wta.accounting_line_type AND lu3.lookup_code(+) = wta.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(wta.gl_batch_id, -1, 2, 1) AND sob.set_of_books_id = ood.set_of_books_id AND gps.application_id = 401 AND gps.set_of_books_id = ood.set_of_books_id AND gps.period_name = jeh.period_name /* AND wta.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 sob.set_of_books_id = jel.ledger_id AND wta.gl_batch_id = R.reference_1 AND R.gl_sl_link_id IS NULL AND R.reference_3 IS NULL AND wta.reference_account+0 = jel.code_combination_id AND nvl(wta.currency_code,sob.currency_code) = jeh.currency_code AND jeh.je_source = 'Inventory' AND jeh.je_category = 'WIP' AND msik.inventory_item_id(+) = we.primary_item_id AND msik.organization_id(+) = we.organization_id

View Text - HTML Formatted

SELECT /*+ ORDERED */ 706
, OOD.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
, 'WT'
, WT.TRANSACTION_ID
, LU2.MEANING
, TO_CHAR(WTA.ACCOUNTING_LINE_TYPE)
, WTA.REFERENCE_ACCOUNT
, NVL(WT.CURRENCY_CODE
, NVL(WTA.CURRENCY_CODE
, SOB.CURRENCY_CODE))
, DECODE(SIGN(NVL(WTA.TRANSACTION_VALUE
, WTA.BASE_TRANSACTION_VALUE))
, 1
, NVL(WTA.TRANSACTION_VALUE
, WTA.BASE_TRANSACTION_VALUE)
, 0
, 0
, NULL)
, DECODE(SIGN(NVL(WTA.TRANSACTION_VALUE
, WTA.BASE_TRANSACTION_VALUE))
, -1
, (-1*NVL(WTA.TRANSACTION_VALUE
, WTA.BASE_TRANSACTION_VALUE))
, NULL)
, DECODE(SIGN(WTA.BASE_TRANSACTION_VALUE)
, 1
, WTA.BASE_TRANSACTION_VALUE
, 0
, 0
, NULL)
, DECODE(SIGN(WTA.BASE_TRANSACTION_VALUE)
, -1
, (-1*WTA.BASE_TRANSACTION_VALUE)
, NULL)
, WT.CURRENCY_CONVERSION_DATE
, WT.CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE
, WT.CURRENCY_CONVERSION_RATE
, TRUNC(WT.TRANSACTION_DATE)
, LU5.MEANING
, DECODE(WTA.GL_BATCH_ID
, -1
, 'N'
, 'Y')
, DECODE(WTA.GL_BATCH_ID
, -1
, TO_NUMBER(NULL)
, WTA.GL_BATCH_ID)
, 'WT'
, WT.TRANSACTION_ID
, 'WTA'
, DECODE(CCE.COST_ELEMENT
, NULL
, LU2.MEANING
, LU2.MEANING||'
, '||CCE.COST_ELEMENT)
, RPAD(DECODE(CCE.COST_ELEMENT
, NULL
, LU2.MEANING
, LU2.MEANING||'
, '||CCE.COST_ELEMENT)
, 132)
, WT.TRANSACTION_UOM
, WT.TRANSACTION_QUANTITY
, DECODE(WTA.PRIMARY_QUANTITY
, NULL
, NULL
, 0
, NULL
, ABS(WTA.BASE_TRANSACTION_VALUE/WTA.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
, WTA.COST_ELEMENT_ID
, CCE.COST_ELEMENT
, JEL.JE_HEADER_ID
, JEL.JE_LINE_NUM
, WTA.LAST_UPDATE_DATE
, WTA.LAST_UPDATED_BY
, WTA.CREATION_DATE
, WTA.CREATED_BY
, WTA.LAST_UPDATE_LOGIN
, WTA.REQUEST_ID
, WTA.PROGRAM_APPLICATION_ID
, WTA.PROGRAM_ID
, WTA.PROGRAM_UPDATE_DATE
FROM GL_JE_LINES JEL
, GL_JE_HEADERS JEH
, GL_IMPORT_REFERENCES R
, GL_PERIOD_STATUSES GPS
, GL_SETS_OF_BOOKS SOB
, GL_DAILY_CONVERSION_TYPES GLCT
, WIP_TRANSACTION_ACCOUNTS WTA
, WIP_TRANSACTIONS WT
, WIP_ENTITIES WE
, WIP_LINES WL
, CST_COST_ELEMENTS CCE
, WIP_FLOW_SCHEDULES WFS
, PO_HEADERS POH
, BOM_RESOURCES BR
, MTL_TRANSACTION_REASONS MTR
, BOM_DEPARTMENTS BD
, ORG_ORGANIZATION_DEFINITIONS OOD
, MTL_SYSTEM_ITEMS_KFV MSIK
, MFG_LOOKUPS LU1
, MFG_LOOKUPS LU2
, MFG_LOOKUPS LU3
, MFG_LOOKUPS LU4
, MFG_LOOKUPS LU5
WHERE WTA.TRANSACTION_ID = WT.TRANSACTION_ID
AND 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(+) = WTA.COST_ELEMENT_ID
AND BR.RESOURCE_ID(+) = WTA.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 = WTA.ACCOUNTING_LINE_TYPE
AND LU3.LOOKUP_CODE(+) = WTA.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(WTA.GL_BATCH_ID
, -1
, 2
, 1)
AND SOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
AND GPS.APPLICATION_ID = 401
AND GPS.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
AND GPS.PERIOD_NAME = JEH.PERIOD_NAME /*
AND WTA.TRANSACTION_DATE BETWEEN GPS.START_DATE
AND (TRUNC(GPS.END_DATE)+0.99999) */
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 SOB.SET_OF_BOOKS_ID = JEL.LEDGER_ID
AND R.GL_SL_LINK_ID IS NOT NULL
AND R.REFERENCE_3 IS NOT NULL
AND WTA.GL_BATCH_ID = R.REFERENCE_1
AND WTA.TRANSACTION_ID = R.REFERENCE_3
AND WTA.REFERENCE_ACCOUNT = JEL.CODE_COMBINATION_ID
AND WTA.GL_SL_LINK_ID = R.GL_SL_LINK_ID
AND JEH.JE_SOURCE = 'INVENTORY'
AND JEH.JE_CATEGORY = 'WIP'
AND MSIK.INVENTORY_ITEM_ID(+) = WE.PRIMARY_ITEM_ID
AND MSIK.ORGANIZATION_ID(+) = WE.ORGANIZATION_ID UNION ALL SELECT /*+ ORDERED */ 706
, OOD.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
, 'WT'
, WT.TRANSACTION_ID
, LU2.MEANING
, TO_CHAR(WTA.ACCOUNTING_LINE_TYPE)
, WTA.REFERENCE_ACCOUNT
, NVL(WT.CURRENCY_CODE
, NVL(WTA.CURRENCY_CODE
, SOB.CURRENCY_CODE))
, DECODE(SIGN(NVL(WTA.TRANSACTION_VALUE
, WTA.BASE_TRANSACTION_VALUE))
, 1
, NVL(WTA.TRANSACTION_VALUE
, WTA.BASE_TRANSACTION_VALUE)
, 0
, 0
, NULL)
, DECODE(SIGN(NVL(WTA.TRANSACTION_VALUE
, WTA.BASE_TRANSACTION_VALUE))
, -1
, (-1*NVL(WTA.TRANSACTION_VALUE
, WTA.BASE_TRANSACTION_VALUE))
, NULL)
, DECODE(SIGN(WTA.BASE_TRANSACTION_VALUE)
, 1
, WTA.BASE_TRANSACTION_VALUE
, 0
, 0
, NULL)
, DECODE(SIGN(WTA.BASE_TRANSACTION_VALUE)
, -1
, (-1*WTA.BASE_TRANSACTION_VALUE)
, NULL)
, WT.CURRENCY_CONVERSION_DATE
, WT.CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE
, WT.CURRENCY_CONVERSION_RATE
, TRUNC(WT.TRANSACTION_DATE)
, LU5.MEANING
, DECODE(WTA.GL_BATCH_ID
, -1
, 'N'
, 'Y')
, DECODE(WTA.GL_BATCH_ID
, -1
, TO_NUMBER(NULL)
, WTA.GL_BATCH_ID)
, 'WT'
, WT.TRANSACTION_ID
, 'WTA'
, LU2.MEANING ||':'||CCE.COST_ELEMENT
, RPAD(CCE.COST_ELEMENT
, 80)
, /* ---------------------------PRODUCT SPECIFIC COLUMNS ------------------------*/ WT.TRANSACTION_UOM
, WT.TRANSACTION_QUANTITY
, DECODE(WTA.PRIMARY_QUANTITY
, NULL
, NULL
, 0
, NULL
, ABS(WTA.BASE_TRANSACTION_VALUE/WTA.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
, WTA.COST_ELEMENT_ID
, CCE.COST_ELEMENT
, JEL.JE_HEADER_ID
, JEL.JE_LINE_NUM
, WTA.LAST_UPDATE_DATE
, WTA.LAST_UPDATED_BY
, WTA.CREATION_DATE
, WTA.CREATED_BY
, WTA.LAST_UPDATE_LOGIN
, WTA.REQUEST_ID
, WTA.PROGRAM_APPLICATION_ID
, WTA.PROGRAM_ID
, WTA.PROGRAM_UPDATE_DATE
FROM GL_JE_LINES JEL
, GL_JE_HEADERS JEH
, GL_IMPORT_REFERENCES R
, GL_PERIOD_STATUSES GPS
, GL_SETS_OF_BOOKS SOB
, GL_DAILY_CONVERSION_TYPES GLCT
, WIP_TRANSACTION_ACCOUNTS WTA
, WIP_TRANSACTIONS WT
, WIP_ENTITIES WE
, WIP_LINES WL
, CST_COST_ELEMENTS CCE
, WIP_FLOW_SCHEDULES WFS
, PO_HEADERS POH
, BOM_RESOURCES BR
, MTL_TRANSACTION_REASONS MTR
, BOM_DEPARTMENTS BD
, ORG_ORGANIZATION_DEFINITIONS OOD
, MTL_SYSTEM_ITEMS_KFV MSIK
, MFG_LOOKUPS LU1
, MFG_LOOKUPS LU2
, MFG_LOOKUPS LU3
, MFG_LOOKUPS LU4
, MFG_LOOKUPS LU5
WHERE WTA.TRANSACTION_ID = WT.TRANSACTION_ID
AND 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(+) = WTA.COST_ELEMENT_ID
AND BR.RESOURCE_ID(+) = WTA.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 = WTA.ACCOUNTING_LINE_TYPE
AND LU3.LOOKUP_CODE(+) = WTA.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(WTA.GL_BATCH_ID
, -1
, 2
, 1)
AND SOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
AND GPS.APPLICATION_ID = 401
AND GPS.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
AND GPS.PERIOD_NAME = JEH.PERIOD_NAME /*
AND WTA.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 SOB.SET_OF_BOOKS_ID = JEL.LEDGER_ID
AND WTA.GL_BATCH_ID = R.REFERENCE_1
AND R.GL_SL_LINK_ID IS NULL
AND R.REFERENCE_3 IS NULL
AND WTA.REFERENCE_ACCOUNT+0 = JEL.CODE_COMBINATION_ID
AND NVL(WTA.CURRENCY_CODE
, SOB.CURRENCY_CODE) = JEH.CURRENCY_CODE
AND JEH.JE_SOURCE = 'INVENTORY'
AND JEH.JE_CATEGORY = 'WIP'
AND MSIK.INVENTORY_ITEM_ID(+) = WE.PRIMARY_ITEM_ID
AND MSIK.ORGANIZATION_ID(+) = WE.ORGANIZATION_ID