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 JMF_SHIKYU_COMPONENTS

Line 2159: ,jmf_shikyu_components comp

2155: ,comp.shikyu_component_id
2156: FROM po_line_locations_all pll
2157: ,jmf_subcontract_orders sub_po
2158: ,po_headers_all ph
2159: ,jmf_shikyu_components comp
2160: ,wip_requirement_operations wip_req
2161: WHERE pll.line_location_id = sub_po.subcontract_po_shipment_id
2162: AND pll.quantity > pll.quantity_received --this can be ignore if allow the allocated qty larger than ordered qty
2163: AND sub_po.oem_organization_id = p_oem_inv_org_id

Line 3196: ,ooha.transactional_curr_code currency_code --or jmf_shikyu_components.Currency ,not ph.currency_code

3192: ,cfr_mid.item_id item_id
3193: ,JMF_SHIKYU_RPT_UTIL.get_item_number(cfr_mid.tp_inv_org_id
3194: ,cfr_mid.item_id) item_number
3195: ,item_v.description item_description
3196: ,ooha.transactional_curr_code currency_code --or jmf_shikyu_components.Currency ,not ph.currency_code
3197: ,p_functional_currency functional_currency
3198: ,oola.unit_selling_price po_unit_price --not pl.unit_price
3199: ,JMF_SHIKYU_RPT_UTIL.convert_amount(ooha.transactional_curr_code
3200: ,p_functional_currency

Line 3252: ,cfr_mid.uom --should jmf_shikyu_components.uom,need rcv.unit_of_measure to conversion?

3248: --,rcv.task_id task_id
3249: ,sub.task_id task_id
3250: --updated to fix project_id related issue start
3251: ,task.task_number task_number
3252: ,cfr_mid.uom --should jmf_shikyu_components.uom,need rcv.unit_of_measure to conversion?
3253: ,cfr_mid.quantity --the SHIKYU component quantity find in rcv for unallocated + unconsumed
3254: ,cfr_mid.primary_uom --rcv.primary_unit_of_measure
3255: ,oola.header_id RepSO_header_id
3256: ,ooha.order_number REP_SO_NUMBER

Line 3714: ,ooha.transactional_curr_code currency_code --or jmf_shikyu_components.Currency ,not ph.currency_code

3710: ,cfr_mid_item_group.site_id site_id
3711: ,cfr_mid_item_group.tp_inv_org_id tp_inv_org_id
3712: ,cfr_mid_item_group.item_id item_id
3713: ,oola.unit_selling_price po_unit_price --not pl.unit_price
3714: ,ooha.transactional_curr_code currency_code --or jmf_shikyu_components.Currency ,not ph.currency_code
3715: ,cfr_mid_item_group.uom --should jmf_shikyu_components.uom,need rcv.unit_of_measure to conversion?
3716: ,jso.project_id project_id
3717: --Added to fix project_number related issue start
3718: ,NVL((SELECT DISTINCT segment1 AS project_number

Line 3715: ,cfr_mid_item_group.uom --should jmf_shikyu_components.uom,need rcv.unit_of_measure to conversion?

3711: ,cfr_mid_item_group.tp_inv_org_id tp_inv_org_id
3712: ,cfr_mid_item_group.item_id item_id
3713: ,oola.unit_selling_price po_unit_price --not pl.unit_price
3714: ,ooha.transactional_curr_code currency_code --or jmf_shikyu_components.Currency ,not ph.currency_code
3715: ,cfr_mid_item_group.uom --should jmf_shikyu_components.uom,need rcv.unit_of_measure to conversion?
3716: ,jso.project_id project_id
3717: --Added to fix project_number related issue start
3718: ,NVL((SELECT DISTINCT segment1 AS project_number
3719: FROM pa_projects_all

Line 3741: ,jmf_shikyu_components jsc

3737: ,msibk.description
3738: ,wro.required_quantity
3739: ,wro.quantity_issued
3740: FROM jmf_subcontract_orders jso
3741: ,jmf_shikyu_components jsc
3742: ,(select DISTINCT cfr_mid_temp.oem_inv_org_id oem_inv_org_id
3743: ,cfr_mid_temp.supplier_id supplier_id
3744: ,cfr_mid_temp.site_id site_id
3745: ,cfr_mid_temp.tp_inv_org_id tp_inv_org_id