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_REPLENISHMENTS

Line 85: --| of the JMF_SHIKYU_REPLENISHMENTS table for |

81: --| in the Get_Available_Replenishment_Po procedure |
82: --| 26-OCT-2005 vchu Replaced dbms_output calls with FND_LOG calls. |
83: --| Also modified the value to populate into the |
84: --| TP_SUPPLIER_ID and TP_SUPPLIER_SITE_ID columns |
85: --| of the JMF_SHIKYU_REPLENISHMENTS table for |
86: --| fixing the wrong value issue of the |
87: --| Manufacturing Partner / MP site as described |
88: --| in bug 4651480. |
89: --| 09-NOV-2005 vchu Modified the query of the c_avail_replen_so_cur |

Line 113: --| JMF_SHIKYU_REPLENISHMENTS to populate the |

109: --| update statements. |
110: --| 21-APR-2006 vchu Modified the Reconcile_Partial_Shipments |
111: --| procedure (for bug 5166092): |
112: --| 1) Modified the INSERT statement for |
113: --| JMF_SHIKYU_REPLENISHMENTS to populate the |
114: --| additional_supply, primary_uom, and the primary |
115: --| uom quantity columns properly. |
116: --| 2) Added an UPDATE statement to update the |
117: --| allocable quantity of the parent Replenishment |

Line 146: --| JMF_SHIKYU_REPLENISHMENTS table. |

142: --| option if creation of Replenishment SOs has |
143: --| already failed when trying to create |
144: --| Replenishment SOs for the Replenishment POs |
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. |

Line 163: --| jmf_shikyu_replenishments record if there were |

159: --| out the sqlerrm. Also replaced hardcoding of |
160: --| the 'S' status by FND_API.G_RET_STS_SUCCESS. |
161: --| 11-MAY-2006 vchu Modified Delete_Allocations to only update |
162: --| the allocated_quantity of the corresponding |
163: --| jmf_shikyu_replenishments record if there were |
164: --| indeed allocations being deleted. The wrong |
165: --| condition was used to check for an empty table |
166: --| before. Should check to see if |
167: --| x_deleted_allocations_tbl.FIRST is NULL or not |

Line 358: l_primary_uom JMF_SHIKYU_REPLENISHMENTS.primary_uom%TYPE;

354:
355: l_qty_to_allocate NUMBER;
356: l_exists VARCHAR2(1) := 'N';
357:
358: l_primary_uom JMF_SHIKYU_REPLENISHMENTS.primary_uom%TYPE;
359: l_replen_uom JMF_SHIKYU_REPLENISHMENTS.uom%TYPE;
360: l_replen_allocated_primary_qty
361: JMF_SHIKYU_REPLENISHMENTS.allocated_primary_uom_quantity%TYPE;
362: l_replen_allocable_primary_qty

Line 359: l_replen_uom JMF_SHIKYU_REPLENISHMENTS.uom%TYPE;

355: l_qty_to_allocate NUMBER;
356: l_exists VARCHAR2(1) := 'N';
357:
358: l_primary_uom JMF_SHIKYU_REPLENISHMENTS.primary_uom%TYPE;
359: l_replen_uom JMF_SHIKYU_REPLENISHMENTS.uom%TYPE;
360: l_replen_allocated_primary_qty
361: JMF_SHIKYU_REPLENISHMENTS.allocated_primary_uom_quantity%TYPE;
362: l_replen_allocable_primary_qty
363: JMF_SHIKYU_REPLENISHMENTS.allocable_primary_uom_quantity%TYPE;

Line 361: JMF_SHIKYU_REPLENISHMENTS.allocated_primary_uom_quantity%TYPE;

357:
358: l_primary_uom JMF_SHIKYU_REPLENISHMENTS.primary_uom%TYPE;
359: l_replen_uom JMF_SHIKYU_REPLENISHMENTS.uom%TYPE;
360: l_replen_allocated_primary_qty
361: JMF_SHIKYU_REPLENISHMENTS.allocated_primary_uom_quantity%TYPE;
362: l_replen_allocable_primary_qty
363: JMF_SHIKYU_REPLENISHMENTS.allocable_primary_uom_quantity%TYPE;
364: l_replen_allocated_qty JMF_SHIKYU_REPLENISHMENTS.allocated_quantity%TYPE;
365: l_replen_allocable_qty JMF_SHIKYU_REPLENISHMENTS.allocable_quantity%TYPE;

Line 363: JMF_SHIKYU_REPLENISHMENTS.allocable_primary_uom_quantity%TYPE;

359: l_replen_uom JMF_SHIKYU_REPLENISHMENTS.uom%TYPE;
360: l_replen_allocated_primary_qty
361: JMF_SHIKYU_REPLENISHMENTS.allocated_primary_uom_quantity%TYPE;
362: l_replen_allocable_primary_qty
363: JMF_SHIKYU_REPLENISHMENTS.allocable_primary_uom_quantity%TYPE;
364: l_replen_allocated_qty JMF_SHIKYU_REPLENISHMENTS.allocated_quantity%TYPE;
365: l_replen_allocable_qty JMF_SHIKYU_REPLENISHMENTS.allocable_quantity%TYPE;
366: l_allocated_uom JMF_SHIKYU_ALLOCATIONS.uom%TYPE;
367: l_allocation_qty JMF_SHIKYU_ALLOCATIONS.allocated_quantity%TYPE;

Line 364: l_replen_allocated_qty JMF_SHIKYU_REPLENISHMENTS.allocated_quantity%TYPE;

360: l_replen_allocated_primary_qty
361: JMF_SHIKYU_REPLENISHMENTS.allocated_primary_uom_quantity%TYPE;
362: l_replen_allocable_primary_qty
363: JMF_SHIKYU_REPLENISHMENTS.allocable_primary_uom_quantity%TYPE;
364: l_replen_allocated_qty JMF_SHIKYU_REPLENISHMENTS.allocated_quantity%TYPE;
365: l_replen_allocable_qty JMF_SHIKYU_REPLENISHMENTS.allocable_quantity%TYPE;
366: l_allocated_uom JMF_SHIKYU_ALLOCATIONS.uom%TYPE;
367: l_allocation_qty JMF_SHIKYU_ALLOCATIONS.allocated_quantity%TYPE;
368: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE := NULL;

Line 365: l_replen_allocable_qty JMF_SHIKYU_REPLENISHMENTS.allocable_quantity%TYPE;

361: JMF_SHIKYU_REPLENISHMENTS.allocated_primary_uom_quantity%TYPE;
362: l_replen_allocable_primary_qty
363: JMF_SHIKYU_REPLENISHMENTS.allocable_primary_uom_quantity%TYPE;
364: l_replen_allocated_qty JMF_SHIKYU_REPLENISHMENTS.allocated_quantity%TYPE;
365: l_replen_allocable_qty JMF_SHIKYU_REPLENISHMENTS.allocable_quantity%TYPE;
366: l_allocated_uom JMF_SHIKYU_ALLOCATIONS.uom%TYPE;
367: l_allocation_qty JMF_SHIKYU_ALLOCATIONS.allocated_quantity%TYPE;
368: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE := NULL;
369: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;

Line 394: -- JMF_SHIKYU_REPLENISHMENTS and get the related attributes

390:
391: -- TO DO: Call reconcile_replen_so_line_split here! (Do we need this?)
392:
393: -- Look for the Replenishment Sales Order Line in the
394: -- JMF_SHIKYU_REPLENISHMENTS and get the related attributes
395: -- by calling a private procedure.
396: Get_Replen_So_Attributes
397: ( p_replen_so_line_id => p_replen_so_line_id
398: , x_header_id => l_replen_so_header_id

Line 576: UPDATE JMF_SHIKYU_REPLENISHMENTS

572: END IF; /* IF l_primary_uom <> l_replen_uom */
573:
574: -- update allocated_quantity and allocated_primary_uom_quantity
575: -- of the Replenishment SO Line after the new allocation
576: UPDATE JMF_SHIKYU_REPLENISHMENTS
577: SET allocated_primary_uom_quantity = l_replen_allocated_primary_qty,
578: allocated_quantity = l_replen_allocated_qty,
579: last_update_date = sysdate,
580: last_updated_by = FND_GLOBAL.user_id,

Line 611: ' not in JMF_SHIKYU_REPLENISHMENTS table');

607: THEN
608: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
609: , G_MODULE_PREFIX || l_api_name || '.g_replen_so_line_not_exist'
610: , 'Sales Order with ID ' || p_replen_so_line_id ||
611: ' not in JMF_SHIKYU_REPLENISHMENTS table');
612: END IF;
613:
614: WHEN OTHERS THEN
615:

Line 856: FROM jmf_shikyu_replenishments jsr,

852: jsr.uom,
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

Line 1290: FROM jmf_shikyu_replenishments jsr

1286: AND NVL(pla.cancel_flag, 'N') = 'N'
1287: AND NVL(plla.cancel_flag, 'N') = 'N'
1288: AND plla.unit_meas_lookup_code = muomv.unit_of_measure
1289: AND NOT EXISTS (SELECT jsr.replenishment_so_line_id
1290: FROM jmf_shikyu_replenishments jsr
1291: WHERE jsr.replenishment_po_shipment_id = plla.line_location_id)
1292: ORDER BY NVL(plla.need_by_date, plla.promised_date),
1293: pha.segment1,
1294: pla.line_num,

Line 1629: -- JMF_SHIKYU_REPLENISHMENTS table

1625: END IF;
1626: -- *** vchu end: new code 8/18
1627:
1628: -- Insert the new Replenishment SO Line into the
1629: -- JMF_SHIKYU_REPLENISHMENTS table
1630: Populate_Replenishment
1631: ( p_replen_so_line_id => l_new_replen_so_line_id
1632: , p_replen_po_shipment_id => l_new_replen_po_shipment_id
1633: , p_component_id => p_component_id

Line 1923: -- JMF_SHIKYU_REPLENISHMENTS table

1919: || l_new_order_line_id);
1920: END IF;
1921:
1922: -- Insert the new Replenishment SO Line into the
1923: -- JMF_SHIKYU_REPLENISHMENTS table
1924: Populate_Replenishment
1925: ( p_replen_so_line_id => l_new_order_line_id
1926: , p_replen_po_shipment_id => l_replen_po_rec.replenishment_po_shipment_id
1927: , p_component_id => p_component_id

Line 3074: FROM JMF_SHIKYU_REPLENISHMENTS jsr

3070:
3071: -- Get UOM of the Replenishment SO Line
3072: SELECT jsr.uom
3073: INTO l_replen_uom
3074: FROM JMF_SHIKYU_REPLENISHMENTS jsr
3075: WHERE jsr.replenishment_so_line_id = x_deleted_allocations_tbl(l_tbl_index).replenishment_so_line_id;
3076:
3077: IF l_replen_uom <> x_deleted_allocations_tbl(l_tbl_index).qty_uom
3078: THEN

Line 3095: UPDATE jmf_shikyu_replenishments

3091: l_deleted_primary_uom_qty := x_deleted_allocations_tbl(l_tbl_index).qty;
3092:
3093: END IF;
3094:
3095: UPDATE jmf_shikyu_replenishments
3096: SET allocated_quantity = allocated_quantity - l_deleted_primary_uom_qty,
3097: allocated_primary_uom_quantity
3098: = allocated_primary_uom_quantity - x_deleted_allocations_tbl(l_tbl_index).qty,
3099: last_update_date = sysdate,

Line 3171: FROM jmf_shikyu_replenishments jsr,

3167: jsr.uom,
3168: oola.ordered_quantity,
3169: jsr.primary_uom,
3170: oola.schedule_ship_date
3171: FROM jmf_shikyu_replenishments jsr,
3172: oe_order_lines_all oola
3173: WHERE jsr.replenishment_so_line_id = oola.line_id
3174: AND jsr.status <> 'CLOSED'
3175: AND jsr.status <> 'CANCELLED'

Line 3261: UPDATE JMF_SHIKYU_REPLENISHMENTS

3257:
3258: END IF; /* IF l_ordered_qty > l_closed_so_line_rec.qty */
3259:
3260: -- Updating the allocable quantity to the shipped quantity of the SO Line
3261: UPDATE JMF_SHIKYU_REPLENISHMENTS
3262: SET allocable_quantity = l_closed_so_line_rec.qty,
3263: allocable_primary_uom_quantity = l_closed_so_line_rec.primary_uom_qty,
3264: status = 'CLOSED',
3265: last_update_date = sysdate,

Line 3349: l_allocable_qty JMF_SHIKYU_REPLENISHMENTS.allocable_quantity%TYPE;

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;
3353: l_shipped_primary_qty NUMBER;

Line 3350: l_allocable_primary_qty JMF_SHIKYU_REPLENISHMENTS.allocable_primary_uom_quantity%TYPE;

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;
3353: l_shipped_primary_qty NUMBER;
3354: l_shipped_qty OE_ORDER_LINES_ALL.shipped_quantity%TYPE;

Line 3351: l_allocated_primary_qty JMF_SHIKYU_REPLENISHMENTS.allocated_primary_uom_quantity%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;
3353: l_shipped_primary_qty NUMBER;
3354: l_shipped_qty OE_ORDER_LINES_ALL.shipped_quantity%TYPE;
3355: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;

Line 3434: FROM JMF_SHIKYU_REPLENISHMENTS jsr,

3430: l_allocable_primary_qty,
3431: l_allocated_primary_qty,
3432: l_shipped_primary_qty,
3433: l_ordered_uom
3434: FROM JMF_SHIKYU_REPLENISHMENTS jsr,
3435: OE_ORDER_LINES_ALL oola
3436: WHERE jsr.REPLENISHMENT_SO_LINE_ID = p_replen_order_line_id
3437: AND jsr.replenishment_so_line_id = oola.line_id;
3438:

Line 3483: -- Remove the Replenishment SO Line from the JMF_SHIKYU_REPLENISHMENTS table,

3479: , P_REPLEN_SO_LINE_ID => p_replen_order_line_id
3480: , X_DELETED_ALLOCATIONS_TBL => l_reduced_allocations_tbl
3481: );
3482:
3483: -- Remove the Replenishment SO Line from the JMF_SHIKYU_REPLENISHMENTS table,
3484: -- since excess qty = allocable qty, and hence there are no available qty on
3485: -- this Replenishment SO Line anymore
3486: DELETE FROM jmf_shikyu_replenishments
3487: WHERE replenishment_so_line_id = p_replen_order_line_id;

Line 3486: DELETE FROM jmf_shikyu_replenishments

3482:
3483: -- Remove the Replenishment SO Line from the JMF_SHIKYU_REPLENISHMENTS table,
3484: -- since excess qty = allocable qty, and hence there are no available qty on
3485: -- this Replenishment SO Line anymore
3486: DELETE FROM jmf_shikyu_replenishments
3487: WHERE replenishment_so_line_id = p_replen_order_line_id;
3488:
3489: -- Loop through the table containing the subcontracting orders
3490: -- being deallocated by the Delete_Allocations procedure,

Line 3547: UPDATE JMF_SHIKYU_REPLENISHMENTS

3543:
3544: -- Update the allocable qty of the Replensiment SO Line being reconciled, so that
3545: -- it will not be reallocated again to the Subcontracting Order Shipments being
3546: -- deallocated from it in order to reconcile the excess qty
3547: UPDATE JMF_SHIKYU_REPLENISHMENTS
3548: SET allocable_quantity = l_allocable_qty,
3549: allocable_primary_uom_quantity = l_allocable_primary_qty,
3550: last_update_date = sysdate,
3551: last_updated_by = FND_GLOBAL.user_id,

Line 3734: FROM JMF_SHIKYU_REPLENISHMENTS jsr

3730: , jsa.subcontract_po_shipment_id subcontract_po_shipment_id
3731: , jsr.ALLOCABLE_PRIMARY_UOM_QUANTITY allocable_primary_UOM_quantity
3732: , jsr.allocable_quantity allocable_quantity
3733: , jsr.allocated_quantity allocated_quantity
3734: FROM JMF_SHIKYU_REPLENISHMENTS jsr
3735: , OE_ORDER_LINES_ALL oel
3736: , OE_ORDER_HEADERS_ALL oeh
3737: , JMF_SHIKYU_ALLOCATIONS jsa
3738: WHERE oeh.header_id = jsr.REPLENISHMENT_SO_HEADER_ID

Line 3998: DELETE FROM JMF_SHIKYU_REPLENISHMENTS

3994: ELSE
3995: l_deleted_qty := 0;
3996: END IF; /* IF l_deleted_allocations_tbl.COUNT > 0 */
3997:
3998: DELETE FROM JMF_SHIKYU_REPLENISHMENTS
3999: WHERE REPLENISHMENT_SO_LINE_ID =
4000: C_SHIKYU_REPLENISHMENT_rec.REPLENISHMENT_SO_LINE_ID
4001: AND REPLENISHMENT_SO_HEADER_ID =
4002: C_SHIKYU_REPLENISHMENT_rec.REPLENISHMENT_SO_header_id ;

Line 4007: , 'JMFVSKAB :AFter DELETE FROM JMF_SHIKYU_REPLENISHMENTS '

4003:
4004: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4005: THEN
4006: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4007: , 'JMFVSKAB :AFter DELETE FROM JMF_SHIKYU_REPLENISHMENTS '
4008: , C_SHIKYU_REPLENISHMENT_rec.REPLENISHMENT_SO_LINE_ID );
4009: END IF;
4010:
4011:

Line 4060: FROM JMF_SHIKYU_REPLENISHMENTS

4056: SELECT UOM,
4057: PRIMARY_UOM
4058: INTO l_uom,
4059: l_primary_uom
4060: FROM JMF_SHIKYU_REPLENISHMENTS
4061: WHERE REPLENISHMENT_SO_LINE_ID =
4062: C_SHIKYU_REPLENISHMENT_rec.REPLENISHMENT_SO_LINE_ID;
4063:
4064: -- Converting the new allocable quantity of the parent SO Line

Line 4140: UPDATE JMF_SHIKYU_REPLENISHMENTS

4136: -- Need to update the allocable quantity columns of the parent
4137: -- Replenishment SO Line, since some of this quantity has been
4138: -- splitted into the child SO Lines. This needs to be done in
4139: -- order to prevent over-allocation of the parent SO Line.
4140: UPDATE JMF_SHIKYU_REPLENISHMENTS
4141: SET allocable_quantity =
4142: C_SHIKYU_REPLENISHMENT_rec.oel_ordered_quantity,
4143: allocable_primary_uom_quantity = l_primary_uom_qty
4144: WHERE REPLENISHMENT_SO_LINE_ID =

Line 4150: , 'JMFVSKAB :after UPDATE JMF_SHIKYU_REPLENISHMENTS '

4146:
4147: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4148: THEN
4149: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4150: , 'JMFVSKAB :after UPDATE JMF_SHIKYU_REPLENISHMENTS '
4151: , C_SHIKYU_REPLENISHMENT_rec.REPLENISHMENT_SO_LINE_ID );
4152: END IF;
4153:
4154: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

Line 4212: INSERT INTO JMF_SHIKYU_REPLENISHMENTS

4208:
4209: -- Insert ONLY if the C_child_so_lines_rec.line_id is not already
4210: -- present in the table
4211:
4212: INSERT INTO JMF_SHIKYU_REPLENISHMENTS
4213: ( REPLENISHMENT_SO_LINE_ID
4214: , REPLENISHMENT_SO_HEADER_ID
4215: , SCHEDULE_SHIP_DATE
4216: , REPLENISHMENT_PO_HEADER_ID

Line 4275: FROM JMF_SHIKYU_REPLENISHMENTS jsr

4271: , REQUEST_ID
4272: , PROGRAM_APPLICATION_ID
4273: , PROGRAM_ID
4274: , PROGRAM_UPDATE_DATE
4275: FROM JMF_SHIKYU_REPLENISHMENTS jsr
4276: WHERE REPLENISHMENT_SO_LINE_ID =
4277: C_SHIKYU_REPLENISHMENT_rec.REPLENISHMENT_SO_LINE_ID
4278: AND NOT EXISTS (
4279: SELECT jsr1.REPLENISHMENT_SO_LINE_ID

Line 4280: FROM JMF_SHIKYU_REPLENISHMENTS jsr1

4276: WHERE REPLENISHMENT_SO_LINE_ID =
4277: C_SHIKYU_REPLENISHMENT_rec.REPLENISHMENT_SO_LINE_ID
4278: AND NOT EXISTS (
4279: SELECT jsr1.REPLENISHMENT_SO_LINE_ID
4280: FROM JMF_SHIKYU_REPLENISHMENTS jsr1
4281: WHERE jsr1.REPLENISHMENT_SO_LINE_ID =
4282: C_child_so_lines_rec.line_id );
4283:
4284: /*AND REPLENISHMENT_SO_HEADER_ID =

Line 4468: FROM JMF_SHIKYU_REPLENISHMENTS jsr,

4464: x_allocated_primary_uom_qty,
4465: x_uom,
4466: x_primary_uom,
4467: x_replen_so_line_exists
4468: FROM JMF_SHIKYU_REPLENISHMENTS jsr,
4469: OE_ORDER_LINES_ALL oola
4470: WHERE jsr.replenishment_so_line_id = p_replen_so_line_id
4471: AND jsr.replenishment_so_line_id = oola.line_id;
4472:

Line 4567: l_tp_supplier_id JMF_SHIKYU_REPLENISHMENTS.tp_supplier_id%TYPE;

4563: l_replen_po_line_id PO_LINE_LOCATIONS_ALL.po_line_id%TYPE;
4564: --l_supplier_id PO_HEADERS_ALL.vendor_id%TYPE;
4565: --l_supplier_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
4566:
4567: l_tp_supplier_id JMF_SHIKYU_REPLENISHMENTS.tp_supplier_id%TYPE;
4568: l_tp_supplier_site_id JMF_SHIKYU_REPLENISHMENTS.tp_supplier_site_id%TYPE;
4569:
4570: -- Information computed for JMF_SHIKYU_REPLENISHMENTS
4571:

Line 4568: l_tp_supplier_site_id JMF_SHIKYU_REPLENISHMENTS.tp_supplier_site_id%TYPE;

4564: --l_supplier_id PO_HEADERS_ALL.vendor_id%TYPE;
4565: --l_supplier_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
4566:
4567: l_tp_supplier_id JMF_SHIKYU_REPLENISHMENTS.tp_supplier_id%TYPE;
4568: l_tp_supplier_site_id JMF_SHIKYU_REPLENISHMENTS.tp_supplier_site_id%TYPE;
4569:
4570: -- Information computed for JMF_SHIKYU_REPLENISHMENTS
4571:
4572: l_primary_uom_qty JMF_SHIKYU_REPLENISHMENTS.ordered_primary_uom_quantity%TYPE;

Line 4570: -- Information computed for JMF_SHIKYU_REPLENISHMENTS

4566:
4567: l_tp_supplier_id JMF_SHIKYU_REPLENISHMENTS.tp_supplier_id%TYPE;
4568: l_tp_supplier_site_id JMF_SHIKYU_REPLENISHMENTS.tp_supplier_site_id%TYPE;
4569:
4570: -- Information computed for JMF_SHIKYU_REPLENISHMENTS
4571:
4572: l_primary_uom_qty JMF_SHIKYU_REPLENISHMENTS.ordered_primary_uom_quantity%TYPE;
4573: l_primary_uom JMF_SHIKYU_REPLENISHMENTS.primary_uom%TYPE;
4574:

Line 4572: l_primary_uom_qty JMF_SHIKYU_REPLENISHMENTS.ordered_primary_uom_quantity%TYPE;

4568: l_tp_supplier_site_id JMF_SHIKYU_REPLENISHMENTS.tp_supplier_site_id%TYPE;
4569:
4570: -- Information computed for JMF_SHIKYU_REPLENISHMENTS
4571:
4572: l_primary_uom_qty JMF_SHIKYU_REPLENISHMENTS.ordered_primary_uom_quantity%TYPE;
4573: l_primary_uom JMF_SHIKYU_REPLENISHMENTS.primary_uom%TYPE;
4574:
4575: BEGIN
4576:

Line 4573: l_primary_uom JMF_SHIKYU_REPLENISHMENTS.primary_uom%TYPE;

4569:
4570: -- Information computed for JMF_SHIKYU_REPLENISHMENTS
4571:
4572: l_primary_uom_qty JMF_SHIKYU_REPLENISHMENTS.ordered_primary_uom_quantity%TYPE;
4573: l_primary_uom JMF_SHIKYU_REPLENISHMENTS.primary_uom%TYPE;
4574:
4575: BEGIN
4576:
4577: IF (g_fnd_debug = 'Y' AND

Line 4699: INSERT INTO JMF_SHIKYU_REPLENISHMENTS

4695: || ', l_primary_uom_qty = ' || l_primary_uom_qty
4696: );
4697: END IF;
4698:
4699: INSERT INTO JMF_SHIKYU_REPLENISHMENTS
4700: ( replenishment_so_line_id
4701: , replenishment_so_header_id
4702: , schedule_ship_date
4703: , replenishment_po_header_id

Line 5107: FROM JMF_SHIKYU_REPLENISHMENTS

5103:
5104: -- Get UOM of the Replenishment SO Line
5105: SELECT uom
5106: INTO l_replen_uom
5107: FROM JMF_SHIKYU_REPLENISHMENTS
5108: WHERE replenishment_so_line_id = p_replen_so_line_id;
5109:
5110: IF (g_fnd_debug = 'Y' AND
5111: FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE)

Line 5161: UPDATE JMF_SHIKYU_REPLENISHMENTS

5157:
5158: -- Update the allocated and allocable quantities (and their primary
5159: -- UOM counterparts) of the Replenishment SO Line that was deallocated
5160: -- from the Subcontracting Component specified by the IN parameters
5161: UPDATE JMF_SHIKYU_REPLENISHMENTS
5162: SET allocated_quantity = allocated_quantity - l_remain_qty_to_reduce,
5163: allocated_primary_uom_quantity = allocated_primary_uom_quantity - l_reduce_replen_uom_qty
5164: WHERE replenishment_so_line_id = p_replen_so_line_id;
5165: