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_ALLOCATION_PVT dependencies on JMF_SHIKYU_COMPONENTS

Line 149: --| the jmf_shikyu_components table. |

145: --| that do not yet present in the |
146: --| JMF_SHIKYU_REPLENISHMENTS table. |
147: --| 08-MAY-2006 vchu Modified validate_price to consider the uom |
148: --| column first before the primary uom column of |
149: --| the jmf_shikyu_components table. |
150: --| Also added debug log messages. |
151: --| 09-MAY-2006 vchu Added a call to Validate_Project_Task_Ref after |
152: --| calling Create_New_Replenishment_Po_So in |
153: --| Allocate_Syncship_Comp, to make sure that the |

Line 1488: l_component_uom JMF_SHIKYU_COMPONENTS.uom%TYPE;

1484:
1485: l_api_name CONSTANT VARCHAR2(30) := 'Create_New_Replenishment_Po_So';
1486: l_api_version CONSTANT NUMBER := 1.0;
1487:
1488: l_component_uom JMF_SHIKYU_COMPONENTS.uom%TYPE;
1489: l_primary_uom JMF_SHIKYU_COMPONENTS.primary_uom%TYPE;
1490: l_component_price JMF_SHIKYU_COMPONENTS.shikyu_component_price%TYPE;
1491: l_primary_uom_price JMF_SHIKYU_COMPONENTS.primary_uom_price%TYPE;
1492: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;

Line 1489: l_primary_uom JMF_SHIKYU_COMPONENTS.primary_uom%TYPE;

1485: l_api_name CONSTANT VARCHAR2(30) := 'Create_New_Replenishment_Po_So';
1486: l_api_version CONSTANT NUMBER := 1.0;
1487:
1488: l_component_uom JMF_SHIKYU_COMPONENTS.uom%TYPE;
1489: l_primary_uom JMF_SHIKYU_COMPONENTS.primary_uom%TYPE;
1490: l_component_price JMF_SHIKYU_COMPONENTS.shikyu_component_price%TYPE;
1491: l_primary_uom_price JMF_SHIKYU_COMPONENTS.primary_uom_price%TYPE;
1492: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
1493: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;

Line 1490: l_component_price JMF_SHIKYU_COMPONENTS.shikyu_component_price%TYPE;

1486: l_api_version CONSTANT NUMBER := 1.0;
1487:
1488: l_component_uom JMF_SHIKYU_COMPONENTS.uom%TYPE;
1489: l_primary_uom JMF_SHIKYU_COMPONENTS.primary_uom%TYPE;
1490: l_component_price JMF_SHIKYU_COMPONENTS.shikyu_component_price%TYPE;
1491: l_primary_uom_price JMF_SHIKYU_COMPONENTS.primary_uom_price%TYPE;
1492: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
1493: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;
1494: l_new_replen_so_line_id OE_ORDER_LINES_ALL.line_id%TYPE;

Line 1491: l_primary_uom_price JMF_SHIKYU_COMPONENTS.primary_uom_price%TYPE;

1487:
1488: l_component_uom JMF_SHIKYU_COMPONENTS.uom%TYPE;
1489: l_primary_uom JMF_SHIKYU_COMPONENTS.primary_uom%TYPE;
1490: l_component_price JMF_SHIKYU_COMPONENTS.shikyu_component_price%TYPE;
1491: l_primary_uom_price JMF_SHIKYU_COMPONENTS.primary_uom_price%TYPE;
1492: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
1493: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;
1494: l_new_replen_so_line_id OE_ORDER_LINES_ALL.line_id%TYPE;
1495: l_new_replen_po_shipment_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

Line 1776: jmf_shikyu_components jsc

1772: l_tp_organization_id,
1773: l_component_uom,
1774: l_primary_uom
1775: FROM jmf_subcontract_orders jso,
1776: jmf_shikyu_components jsc
1777: WHERE jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
1778: AND jso.subcontract_po_shipment_id = jsc.subcontract_po_shipment_id
1779: AND jsc.shikyu_component_id = p_component_id;
1780:

Line 3347: l_primary_uom JMF_SHIKYU_COMPONENTS.primary_uom%TYPE;

3343:
3344: TYPE l_allocation_detail_tbl_type IS TABLE OF l_allocation_detail_rec_type INDEX BY BINARY_INTEGER;
3345:
3346: l_subcontract_po_shipment_id JMF_SUBCONTRACT_ORDERS.subcontract_po_shipment_id%TYPE;
3347: l_primary_uom JMF_SHIKYU_COMPONENTS.primary_uom%TYPE;
3348: l_component_id JMF_SHIKYU_COMPONENTS.shikyu_component_id%TYPE;
3349: l_allocable_qty JMF_SHIKYU_REPLENISHMENTS.allocable_quantity%TYPE;
3350: l_allocable_primary_qty JMF_SHIKYU_REPLENISHMENTS.allocable_primary_uom_quantity%TYPE;
3351: l_allocated_primary_qty JMF_SHIKYU_REPLENISHMENTS.allocated_primary_uom_quantity%TYPE;

Line 3348: l_component_id JMF_SHIKYU_COMPONENTS.shikyu_component_id%TYPE;

3344: TYPE l_allocation_detail_tbl_type IS TABLE OF l_allocation_detail_rec_type INDEX BY BINARY_INTEGER;
3345:
3346: l_subcontract_po_shipment_id JMF_SUBCONTRACT_ORDERS.subcontract_po_shipment_id%TYPE;
3347: l_primary_uom JMF_SHIKYU_COMPONENTS.primary_uom%TYPE;
3348: l_component_id JMF_SHIKYU_COMPONENTS.shikyu_component_id%TYPE;
3349: l_allocable_qty JMF_SHIKYU_REPLENISHMENTS.allocable_quantity%TYPE;
3350: l_allocable_primary_qty JMF_SHIKYU_REPLENISHMENTS.allocable_primary_uom_quantity%TYPE;
3351: l_allocated_primary_qty JMF_SHIKYU_REPLENISHMENTS.allocated_primary_uom_quantity%TYPE;
3352: l_unallocated_primary_qty NUMBER;

Line 4843: FROM jmf_shikyu_components jsc

4839: ELSE
4840: BEGIN
4841: SELECT count(*)
4842: INTO l_count
4843: FROM jmf_shikyu_components jsc
4844: WHERE jsc.shikyu_component_id = p_component_id
4845: AND jsc.subcontract_po_shipment_id = p_subcontract_po_shipment_id
4846: AND EXISTS (SELECT 'x'
4847: FROM oe_order_lines_all oola,