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 3717: ,ooha.transactional_curr_code currency_code --or jmf_shikyu_components.Currency ,not ph.currency_code

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

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

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

Line 3744: ,jmf_shikyu_components jsc

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