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 859: jmf_subcontract_orders jso,

855: oola.schedule_ship_date,
856: --Bugfix 14246759: Adding actual_shipment_date
857: oola.actual_shipment_date
858: FROM jmf_shikyu_replenishments jsr,
859: jmf_subcontract_orders jso,
860: oe_order_lines_all oola
861: WHERE jsr.oem_organization_id = jso.oem_organization_id
862: AND jsr.tp_organization_id = jso.tp_organization_id
863: AND jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id

Line 898: JMF_SUBCONTRACT_ORDERS jso

894: CURSOR c_wip_date_cur IS
895: SELECT wdj.scheduled_start_date,
896: wdj.scheduled_completion_date
897: FROM WIP_DISCRETE_JOBS wdj,
898: JMF_SUBCONTRACT_ORDERS jso
899: WHERE wdj.wip_entity_id = jso.wip_entity_id
900: AND wdj.organization_id = jso.tp_organization_id
901: AND jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id;
902:

Line 910: JMF_SUBCONTRACT_ORDERS jso

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

Line 1022: (SELECT 1 FROM jmf_subcontract_orders jso

1018:
1019: SELECT organization_code INTO l_oem_organization
1020: FROM mtl_parameters mip
1021: WHERE exists
1022: (SELECT 1 FROM jmf_subcontract_orders jso
1023: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id
1024: AND jso.oem_organization_id = mip.organization_id);
1025:
1026:

Line 1030: (SELECT 1 FROM jmf_subcontract_orders jso

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

Line 1247: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;

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

Line 1248: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;

1244: l_primary_uom MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
1245: l_replen_po_primary_uom MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
1246:
1247: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
1248: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;
1249:
1250: l_avail_replen_po_tbl g_replen_po_qty_tbl_type;
1251: l_avail_replen_po_rec g_replen_po_qty_rec_type;
1252:

Line 1273: FROM jmf_subcontract_orders jso,

1269: NVL(plla.need_by_date, plla.promised_date),
1270: pha.segment1,
1271: pla.line_num,
1272: plla.shipment_num
1273: FROM jmf_subcontract_orders jso,
1274: hr_organization_information hoi,
1275: po_line_locations_all plla,
1276: po_lines_all pla,
1277: po_headers_all pha,

Line 1498: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;

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

Line 1499: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%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;
1502: l_new_replen_qty NUMBER;
1503:

Line 1781: FROM jmf_subcontract_orders jso,

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

Line 2085: JMF_SUBCONTRACT_ORDERS jso

2081: -- different for Pre-positioned and Sync-ship components
2082: SELECT msib.subcontracting_component
2083: INTO l_subcontracting_component
2084: FROM MTL_SYSTEM_ITEMS_B msib,
2085: JMF_SUBCONTRACT_ORDERS jso
2086: WHERE jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
2087: AND msib.inventory_item_id = p_component_id
2088: AND msib.organization_id = jso.tp_organization_id;
2089:

Line 2379: FROM jmf_subcontract_orders jso

2375: FROM mtl_system_items_b msi
2376: WHERE inventory_item_id = p_component_id
2377: AND exists
2378: (SELECT 1
2379: FROM jmf_subcontract_orders jso
2380: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id
2381: AND jso.tp_organization_id = msi.organization_id );
2382:
2383:

Line 3500: l_subcontract_po_shipment_id JMF_SUBCONTRACT_ORDERS.subcontract_po_shipment_id%TYPE;

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

Line 5267: JMF_SUBCONTRACT_ORDERS

5263: oem_organization_id, tp_organization_id
5264: INTO
5265: l_oem_org_id, l_mp_org_id
5266: FROM
5267: JMF_SUBCONTRACT_ORDERS
5268: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id;
5269:
5270: l_subcontracting_type := JMF_SHIKYU_GRP.get_subcontracting_type(l_oem_org_id, l_mp_org_id);
5271:

Line 5370: jmf_subcontract_orders jso

5366: -- project_control_level: Project = 1, Task = 2
5367: SELECT count(*)
5368: INTO l_count
5369: FROM mtl_parameters mtlp,
5370: jmf_subcontract_orders jso
5371: WHERE mtlp.organization_id = jso.tp_organization_id
5372: AND jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
5373: AND ( (mtlp.project_control_level = 1
5374: AND EXISTS (SELECT 'x'

Line 5721: jmf_subcontract_orders jso

5717: select jsa.shikyu_component_id shikyu_component_id,
5718: jsa.subcontract_po_shipment_id subcontract_po_shipment_id,
5719: jso.wip_entity_id wip_entity_id
5720: from jmf_shikyu_allocations jsa,
5721: jmf_subcontract_orders jso
5722: where jsa.replenishment_so_line_id = l_line_id
5723: and jsa.subcontract_po_shipment_id = jso.subcontract_po_shipment_id;
5724:
5725: BEGIN