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_SL_WIP_V

Source

View Text - Preformatted


SELECT 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, wt.last_update_date, wt.last_updated_by, wt.creation_date, wt.created_by, wt.last_update_login, wt.request_id, wt.program_application_id, wt.program_id, wt.program_update_date FROM po_headers poh, mtl_transaction_reasons mtr, bom_departments bd, mfg_lookups lu1, mfg_lookups lu2, mfg_lookups lu3, mfg_lookups lu4, mfg_lookups lu5, wip_lines wl, wip_transactions wt, wip_entities we, bom_resources br, wip_flow_schedules wfs, wip_transaction_accounts wta, cst_cost_elements cce, gl_daily_conversion_types glct, gl_sets_of_books sob, org_organization_definitions ood, mtl_system_items_kfv msik 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 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 wt.organization_id = ood.organization_id AND wt.currency_conversion_type = glct.conversion_type(+) AND br.resource_id(+) = wta.resource_id AND wfs.wip_entity_id (+) = we.wip_entity_id AND msik.inventory_item_id(+) = we.primary_item_id AND msik.organization_id(+) = we.organization_id

View Text - HTML Formatted

SELECT 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
, WT.LAST_UPDATE_DATE
, WT.LAST_UPDATED_BY
, WT.CREATION_DATE
, WT.CREATED_BY
, WT.LAST_UPDATE_LOGIN
, WT.REQUEST_ID
, WT.PROGRAM_APPLICATION_ID
, WT.PROGRAM_ID
, WT.PROGRAM_UPDATE_DATE
FROM PO_HEADERS POH
, MTL_TRANSACTION_REASONS MTR
, BOM_DEPARTMENTS BD
, MFG_LOOKUPS LU1
, MFG_LOOKUPS LU2
, MFG_LOOKUPS LU3
, MFG_LOOKUPS LU4
, MFG_LOOKUPS LU5
, WIP_LINES WL
, WIP_TRANSACTIONS WT
, WIP_ENTITIES WE
, BOM_RESOURCES BR
, WIP_FLOW_SCHEDULES WFS
, WIP_TRANSACTION_ACCOUNTS WTA
, CST_COST_ELEMENTS CCE
, GL_DAILY_CONVERSION_TYPES GLCT
, GL_SETS_OF_BOOKS SOB
, ORG_ORGANIZATION_DEFINITIONS OOD
, MTL_SYSTEM_ITEMS_KFV MSIK
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 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 WT.ORGANIZATION_ID = OOD.ORGANIZATION_ID
AND WT.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE(+)
AND BR.RESOURCE_ID(+) = WTA.RESOURCE_ID
AND WFS.WIP_ENTITY_ID (+) = WE.WIP_ENTITY_ID
AND MSIK.INVENTORY_ITEM_ID(+) = WE.PRIMARY_ITEM_ID
AND MSIK.ORGANIZATION_ID(+) = WE.ORGANIZATION_ID