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_SUBCONTRACT_ORDERS

Line 53: --| against the JMF_SUBCONTRACT_ORDERS record for |

49: --| 07-JUL-2005 vchu Fixed GSCC errors. |
50: --| 01-AUG-2005 vchu Modified the Validate_Project_Task_Ref |
51: --| procedure to validate the project and task |
52: --| reference of a Replenishment Sales Order Line |
53: --| against the JMF_SUBCONTRACT_ORDERS record for |
54: --| the Subcontracting Order instead of the |
55: --| PO_LINES_ALL record. |
56: --| 03-AUG-2005 vchu Added the Initialize procedure to perform API |
57: --| Intialization. |

Line 375: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;

371: l_message VARCHAR(2000);
372: l_status_flag BOOLEAN;
373:
374:
375: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
376: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;
377:
378: g_replen_so_line_not_exist EXCEPTION;
379:

Line 376: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;

372: l_status_flag BOOLEAN;
373:
374:
375: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
376: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;
377:
378: g_replen_so_line_not_exist EXCEPTION;
379:
380: BEGIN

Line 857: jmf_subcontract_orders jso,

853: jsr.allocable_primary_uom_quantity - jsr.allocated_primary_uom_quantity,
854: jsr.primary_uom,
855: oola.schedule_ship_date
856: FROM jmf_shikyu_replenishments jsr,
857: jmf_subcontract_orders jso,
858: oe_order_lines_all oola
859: WHERE jsr.oem_organization_id = jso.oem_organization_id
860: AND jsr.tp_organization_id = jso.tp_organization_id
861: AND jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id

Line 894: JMF_SUBCONTRACT_ORDERS jso

890: CURSOR c_wip_date_cur IS
891: SELECT wdj.scheduled_start_date,
892: wdj.scheduled_completion_date
893: FROM WIP_DISCRETE_JOBS wdj,
894: JMF_SUBCONTRACT_ORDERS jso
895: WHERE wdj.wip_entity_id = jso.wip_entity_id
896: AND wdj.organization_id = jso.tp_organization_id
897: AND jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id;
898:

Line 906: JMF_SUBCONTRACT_ORDERS jso

902: SELECT NVL(mism.intransit_time, 0)
903: , FROM_organization_id
904: , to_organization_id
905: FROM MTL_INTERORG_SHIP_METHODS mism,
906: JMF_SUBCONTRACT_ORDERS jso
907: WHERE mism.from_organization_id = jso.oem_organization_id
908: AND mism.to_organization_id = jso.tp_organization_id
909: AND mism.default_flag = 1
910: AND jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id;

Line 1018: (SELECT 1 FROM jmf_subcontract_orders jso

1014:
1015: SELECT organization_code INTO l_oem_organization
1016: FROM mtl_parameters mip
1017: WHERE exists
1018: (SELECT 1 FROM jmf_subcontract_orders jso
1019: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id
1020: AND jso.oem_organization_id = mip.organization_id);
1021:
1022:

Line 1026: (SELECT 1 FROM jmf_subcontract_orders jso

1022:
1023: SELECT organization_code INTO l_tp_organization
1024: FROM mtl_parameters mip
1025: WHERE exists
1026: (SELECT 1 FROM jmf_subcontract_orders jso
1027: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id
1028: AND jso.tp_organization_id = mip.organization_id);
1029:
1030: fnd_message.set_name('JMF','JMF_SHK_NO_SHIP_METHOD');

Line 1243: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;

1239:
1240: l_primary_uom MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
1241: l_replen_po_primary_uom MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
1242:
1243: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
1244: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;
1245:
1246: l_avail_replen_po_tbl g_replen_po_qty_tbl_type;
1247: l_avail_replen_po_rec g_replen_po_qty_rec_type;

Line 1244: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;

1240: l_primary_uom MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
1241: l_replen_po_primary_uom MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
1242:
1243: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
1244: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;
1245:
1246: l_avail_replen_po_tbl g_replen_po_qty_tbl_type;
1247: l_avail_replen_po_rec g_replen_po_qty_rec_type;
1248:

Line 1269: FROM jmf_subcontract_orders jso,

1265: NVL(plla.need_by_date, plla.promised_date),
1266: pha.segment1,
1267: pla.line_num,
1268: plla.shipment_num
1269: FROM jmf_subcontract_orders jso,
1270: hr_organization_information hoi,
1271: po_line_locations_all plla,
1272: po_lines_all pla,
1273: po_headers_all pha,

Line 1492: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;

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;
1496: l_new_replen_qty NUMBER;

Line 1493: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%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;
1496: l_new_replen_qty NUMBER;
1497:

Line 1775: FROM jmf_subcontract_orders jso,

1771: INTO l_oem_organization_id,
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;

Line 2079: JMF_SUBCONTRACT_ORDERS jso

2075: -- different for Pre-positioned and Sync-ship components
2076: SELECT msib.subcontracting_component
2077: INTO l_subcontracting_component
2078: FROM MTL_SYSTEM_ITEMS_B msib,
2079: JMF_SUBCONTRACT_ORDERS jso
2080: WHERE jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
2081: AND msib.inventory_item_id = p_component_id
2082: AND msib.organization_id = jso.tp_organization_id;
2083:

Line 2373: FROM jmf_subcontract_orders jso

2369: FROM mtl_system_items_b msi
2370: WHERE inventory_item_id = p_component_id
2371: AND exists
2372: (SELECT 1
2373: FROM jmf_subcontract_orders jso
2374: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id
2375: AND jso.tp_organization_id = msi.organization_id );
2376:
2377:

Line 3346: l_subcontract_po_shipment_id JMF_SUBCONTRACT_ORDERS.subcontract_po_shipment_id%TYPE;

3342: );
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;

Line 4823: JMF_SUBCONTRACT_ORDERS

4819: oem_organization_id, tp_organization_id
4820: INTO
4821: l_oem_org_id, l_mp_org_id
4822: FROM
4823: JMF_SUBCONTRACT_ORDERS
4824: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id;
4825:
4826: l_subcontracting_type := JMF_SHIKYU_GRP.get_subcontracting_type(l_oem_org_id, l_mp_org_id);
4827:

Line 4926: jmf_subcontract_orders jso

4922: -- project_control_level: Project = 1, Task = 2
4923: SELECT count(*)
4924: INTO l_count
4925: FROM mtl_parameters mtlp,
4926: jmf_subcontract_orders jso
4927: WHERE mtlp.organization_id = jso.tp_organization_id
4928: AND jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
4929: AND ( (mtlp.project_control_level = 1
4930: AND EXISTS (SELECT 'x'