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.

APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 711: ,MTL_SYSTEM_ITEMS_B_KFV item_f -- the latest view for the item flexfield

707: ,SUM(onhand.transaction_quantity) primary_uom_qty
708: ,onhand.project_id
709: ,onhand.task_id
710: FROM MTL_ONHAND_QUANTITIES onhand
711: ,MTL_SYSTEM_ITEMS_B_KFV item_f -- the latest view for the item flexfield
712: WHERE onhand.organization_id = l_tp_inv_org_id
713: AND onhand.organization_id = item_f.organization_id
714: AND onhand.inventory_item_id = item_f.inventory_item_id
715: AND item_f.subcontracting_component IS NOT NULL --= 'Y'

Line 3595: FROM MTL_SYSTEM_ITEMS_B_KFV msibk

3591:
3592: -- update the SHIKYU_components item number, desc, type info
3593: UPDATE JMF_SHIKYU_CFR_RPT_TEMP temp
3594: SET temp.item_number = (SELECT msibk.concatenated_segments
3595: FROM MTL_SYSTEM_ITEMS_B_KFV msibk
3596: WHERE temp.tp_inv_org_id =
3597: msibk.organization_id
3598: AND temp.item_id =
3599: msibk.inventory_item_id)

Line 3601: FROM MTL_SYSTEM_ITEMS_B_KFV msibk

3597: msibk.organization_id
3598: AND temp.item_id =
3599: msibk.inventory_item_id)
3600: ,temp.item_description = (SELECT msibk.description
3601: FROM MTL_SYSTEM_ITEMS_B_KFV msibk
3602: WHERE temp.tp_inv_org_id =
3603: msibk.organization_id
3604: AND temp.item_id =
3605: msibk.inventory_item_id)

Line 3608: ,MTL_SYSTEM_ITEMS_B_KFV msibk

3604: AND temp.item_id =
3605: msibk.inventory_item_id)
3606: ,temp.replenishment_type = (SELECT flv.meaning
3607: FROM fnd_lookup_values flv
3608: ,MTL_SYSTEM_ITEMS_B_KFV msibk
3609: WHERE flv.LANGUAGE = USERENV('LANG')
3610: AND flv.lookup_type =
3611: 'JMF_SHK_ITEM_REPLEN_TYPE'
3612: AND msibk.subcontracting_component =

Line 3760: ,MTL_SYSTEM_ITEMS_B_KFV msibk

3756: ,po_headers_all pha_s
3757: ,po_lines_all pla_s
3758: ,po_releases_all pra_s
3759: ,wip_requirement_operations wro
3760: ,MTL_SYSTEM_ITEMS_B_KFV msibk
3761: ,rcv_transactions rt
3762: --Added to get task start
3763: ,pa_tasks task
3764: --Added to get task end

Line 4551: ,MTL_SYSTEM_ITEMS_B_KFV msibk

4547: ,wro.quantity_issued
4548: FROM JMF_SHIKYU_CFR_RPT_TEMP temp
4549: ,jmf_subcontract_orders jso
4550: ,wip_requirement_operations wro
4551: ,MTL_SYSTEM_ITEMS_B_KFV msibk
4552: WHERE temp.rpt_DATA_TYPE = CFR_CRUDE_DATA
4553: AND temp.subpo_shipment_id = jso.subcontract_po_shipment_id
4554: AND jso.oem_organization_id = msibk.organization_id
4555: AND jso.osa_item_id = msibk.inventory_item_id