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_ADJUSTMENT_PROC dependencies on JMF_SUBCONTRACT_ORDERS

Line 113: FROM jmf_shikyu_adjustments --JMF_SUBCONTRACT_ORDERS

109: l_p_max_workers NUMBER;
110:
111: CURSOR c_negative_adj IS
112: SELECT DISTINCT adjustment_id
113: FROM jmf_shikyu_adjustments --JMF_SUBCONTRACT_ORDERS
114: WHERE request_id IS NULL
115: AND batch_id IS NULL
116: AND adjustment < 0
117: --AND group_id = NVL(p_group_id,group_id) --group_id is for future use

Line 122: FROM jmf_shikyu_adjustments --JMF_SUBCONTRACT_ORDERS

118: ORDER BY adjustment_id;
119:
120: CURSOR c_positive_adj IS
121: SELECT DISTINCT adjustment_id
122: FROM jmf_shikyu_adjustments --JMF_SUBCONTRACT_ORDERS
123: WHERE request_id IS NULL
124: AND batch_id IS NULL
125: AND adjustment > 0
126: --AND group_id = NVL(p_group_id,group_id) --group_id is for future use

Line 1437: ,jmf_subcontract_orders jso

1433: ,jsc.primary_uom
1434: INTO l_wip_consumed_qty
1435: ,l_wip_consumed_uom
1436: FROM wip_requirement_operations wro
1437: ,jmf_subcontract_orders jso
1438: ,jmf_shikyu_components jsc
1439: WHERE wro.wip_entity_id = jso.wip_entity_id
1440: AND wro.organization_id = jso.tp_organization_id
1441: AND wro.inventory_item_id = jsc.shikyu_component_id