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 3598: FROM MTL_SYSTEM_ITEMS_B_KFV msibk

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

Line 3604: FROM MTL_SYSTEM_ITEMS_B_KFV msibk

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

Line 3611: ,MTL_SYSTEM_ITEMS_B_KFV msibk

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

Line 3763: ,MTL_SYSTEM_ITEMS_B_KFV msibk

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

Line 4554: ,MTL_SYSTEM_ITEMS_B_KFV msibk

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