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 1494: l_component_uom JMF_SHIKYU_COMPONENTS.uom%TYPE;

1490:
1491: l_api_name CONSTANT VARCHAR2(30) := 'Create_New_Replenishment_Po_So';
1492: l_api_version CONSTANT NUMBER := 1.0;
1493:
1494: l_component_uom JMF_SHIKYU_COMPONENTS.uom%TYPE;
1495: l_primary_uom JMF_SHIKYU_COMPONENTS.primary_uom%TYPE;
1496: l_component_price JMF_SHIKYU_COMPONENTS.shikyu_component_price%TYPE;
1497: l_primary_uom_price JMF_SHIKYU_COMPONENTS.primary_uom_price%TYPE;
1498: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;

Line 1495: l_primary_uom JMF_SHIKYU_COMPONENTS.primary_uom%TYPE;

1491: l_api_name CONSTANT VARCHAR2(30) := 'Create_New_Replenishment_Po_So';
1492: l_api_version CONSTANT NUMBER := 1.0;
1493:
1494: l_component_uom JMF_SHIKYU_COMPONENTS.uom%TYPE;
1495: l_primary_uom JMF_SHIKYU_COMPONENTS.primary_uom%TYPE;
1496: l_component_price JMF_SHIKYU_COMPONENTS.shikyu_component_price%TYPE;
1497: l_primary_uom_price JMF_SHIKYU_COMPONENTS.primary_uom_price%TYPE;
1498: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
1499: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;

Line 1496: l_component_price JMF_SHIKYU_COMPONENTS.shikyu_component_price%TYPE;

1492: l_api_version CONSTANT NUMBER := 1.0;
1493:
1494: l_component_uom JMF_SHIKYU_COMPONENTS.uom%TYPE;
1495: l_primary_uom JMF_SHIKYU_COMPONENTS.primary_uom%TYPE;
1496: l_component_price JMF_SHIKYU_COMPONENTS.shikyu_component_price%TYPE;
1497: l_primary_uom_price JMF_SHIKYU_COMPONENTS.primary_uom_price%TYPE;
1498: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
1499: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;
1500: l_new_replen_so_line_id OE_ORDER_LINES_ALL.line_id%TYPE;

Line 1497: l_primary_uom_price JMF_SHIKYU_COMPONENTS.primary_uom_price%TYPE;

1493:
1494: l_component_uom JMF_SHIKYU_COMPONENTS.uom%TYPE;
1495: l_primary_uom JMF_SHIKYU_COMPONENTS.primary_uom%TYPE;
1496: l_component_price JMF_SHIKYU_COMPONENTS.shikyu_component_price%TYPE;
1497: l_primary_uom_price JMF_SHIKYU_COMPONENTS.primary_uom_price%TYPE;
1498: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
1499: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;
1500: l_new_replen_so_line_id OE_ORDER_LINES_ALL.line_id%TYPE;
1501: l_new_replen_po_shipment_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

Line 1782: jmf_shikyu_components jsc

1778: l_tp_organization_id,
1779: l_component_uom,
1780: l_primary_uom
1781: FROM jmf_subcontract_orders jso,
1782: jmf_shikyu_components jsc
1783: WHERE jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
1784: AND jso.subcontract_po_shipment_id = jsc.subcontract_po_shipment_id
1785: AND jsc.shikyu_component_id = p_component_id;
1786:

Line 3501: l_primary_uom JMF_SHIKYU_COMPONENTS.primary_uom%TYPE;

3497:
3498: TYPE l_allocation_detail_tbl_type IS TABLE OF l_allocation_detail_rec_type INDEX BY BINARY_INTEGER;
3499:
3500: l_subcontract_po_shipment_id JMF_SUBCONTRACT_ORDERS.subcontract_po_shipment_id%TYPE;
3501: l_primary_uom JMF_SHIKYU_COMPONENTS.primary_uom%TYPE;
3502: l_component_id JMF_SHIKYU_COMPONENTS.shikyu_component_id%TYPE;
3503: l_allocable_qty JMF_SHIKYU_REPLENISHMENTS.allocable_quantity%TYPE;
3504: l_allocable_primary_qty JMF_SHIKYU_REPLENISHMENTS.allocable_primary_uom_quantity%TYPE;
3505: l_allocated_primary_qty JMF_SHIKYU_REPLENISHMENTS.allocated_primary_uom_quantity%TYPE;

Line 3502: l_component_id JMF_SHIKYU_COMPONENTS.shikyu_component_id%TYPE;

3498: TYPE l_allocation_detail_tbl_type IS TABLE OF l_allocation_detail_rec_type INDEX BY BINARY_INTEGER;
3499:
3500: l_subcontract_po_shipment_id JMF_SUBCONTRACT_ORDERS.subcontract_po_shipment_id%TYPE;
3501: l_primary_uom JMF_SHIKYU_COMPONENTS.primary_uom%TYPE;
3502: l_component_id JMF_SHIKYU_COMPONENTS.shikyu_component_id%TYPE;
3503: l_allocable_qty JMF_SHIKYU_REPLENISHMENTS.allocable_quantity%TYPE;
3504: l_allocable_primary_qty JMF_SHIKYU_REPLENISHMENTS.allocable_primary_uom_quantity%TYPE;
3505: l_allocated_primary_qty JMF_SHIKYU_REPLENISHMENTS.allocated_primary_uom_quantity%TYPE;
3506: l_unallocated_primary_qty NUMBER;

Line 5287: FROM jmf_shikyu_components jsc

5283: ELSE
5284: BEGIN
5285: SELECT count(*)
5286: INTO l_count
5287: FROM jmf_shikyu_components jsc
5288: WHERE jsc.shikyu_component_id = p_component_id
5289: AND jsc.subcontract_po_shipment_id = p_subcontract_po_shipment_id
5290: AND EXISTS (SELECT 'x'
5291: FROM oe_order_lines_all oola,