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.WMS_REPLENISHMENT_PVT dependencies on WMS_REPLENISHMENT_DETAILS

Line 484: from WMS_REPLENISHMENT_DETAILS wrd

480: and MR.SUBINVENTORY_CODE IS NOT NULL --locator is not needed,
481: )-- Exclude detailed RSV
482: AND NOT EXISTS
483: (select wrd.demand_line_detail_id
484: from WMS_REPLENISHMENT_DETAILS wrd
485: where wrd.demand_line_detail_id = wdd.delivery_detail_id
486: and wrd.demand_line_id = wdd.source_line_id
487: and wrd.organization_id = wdd.organization_id
488: AND wrd.organization_id = p_org_id)

Line 2209: from WMS_REPLENISHMENT_DETAILS wrd

2205: AND party_id = nvl(p_customer_id,party_id)))
2206: AND wdd.source_header_type_id = nvl(P_ORDER_TYPE_ID,source_header_type_id)
2207: AND NOT exists
2208: (select wrd.demand_line_detail_id
2209: from WMS_REPLENISHMENT_DETAILS wrd
2210: where wrd.demand_line_detail_id = wdd.delivery_detail_id
2211: and wrd.demand_line_id = wdd.source_line_id
2212: and wrd.organization_id = wdd.organization_id
2213: And wrd.organization_id = p_organization_id)

Line 2696: FROM wms_replenishment_details

2692: IF l_repl_level IS NULL THEN
2693: BEGIN
2694: SELECT repl_level
2695: INTO l_repl_level
2696: FROM wms_replenishment_details
2697: WHERE source_type_id = 4
2698: AND organization_id = p_organization_id
2699: AND inventory_item_id = p_inventory_item_id
2700: AND source_header_id = p_move_order_header_id

Line 3984: INSERT INTO wms_replenishment_details

3980: END IF;
3981:
3982: -- BULK UPLOAD ALL DEMAND RECORDS IN THE WRD TABLE
3983: FORALL k in 1 .. l_demand_line_detail_id_tab.COUNT()
3984: INSERT INTO wms_replenishment_details
3985: (Replenishment_id,
3986: Organization_id,
3987: source_header_id,
3988: Source_line_id,

Line 4007: WMS_REPLENISHMENT_DETAILS_S.NEXTVAL,

4003: CREATED_BY,
4004: LAST_UPDATED_BY,
4005: LAST_UPDATE_LOGIN
4006: )VALUES (
4007: WMS_REPLENISHMENT_DETAILS_S.NEXTVAL,
4008: l_organization_id_tab(k),
4009: l_mo_header_id_tab(k),
4010: l_mo_line_id_tab(k),
4011: NULL,

Line 4071: INSERT INTO wms_replenishment_details

4067: inv_cache.item_rec.primary_uom_code)),
4068: g_conversion_precision);
4069:
4070:
4071: INSERT INTO wms_replenishment_details
4072: (Replenishment_id,
4073: Organization_id,
4074: source_header_id,
4075: Source_line_id,

Line 4095: WMS_REPLENISHMENT_DETAILS_S.NEXTVAL, --Replenishment_id,

4091: LAST_UPDATED_BY,
4092: LAST_UPDATE_LOGIN
4093: )
4094: SELECT
4095: WMS_REPLENISHMENT_DETAILS_S.NEXTVAL, --Replenishment_id,
4096: p_consol_item_repl_tbl(i).organization_id, --Organization_id,
4097: l_x_trolin_tbl(1).header_id, -- source_header_id,
4098: l_x_trolin_tbl(1).line_id, -- Source_line_id,
4099: NULL, -- Source_line_detail_id,

Line 4576: from WMS_REPLENISHMENT_DETAILS wrd

4572: and mtrl.line_status in (3, 7) -- only approved and pre-approved
4573: and mtrh.move_order_type = 2 -- for replenishment only
4574: AND not exists
4575: (select WRD.Source_line_id
4576: from WMS_REPLENISHMENT_DETAILS wrd
4577: where WRD.source_header_id = MTRL.HEADER_ID
4578: AND WRD.Source_line_id = MTRL.LINE_ID
4579: And wrd.organization_id = mtrl.organization_id
4580: And wrd.organization_id = p_org_id )

Line 4599: FROM WMS_REPLENISHMENT_DETAILS wrd, wsh_delivery_details wdd

4595: (
4596: SELECT WRD.Source_line_id, WRD.source_header_id,
4597: wrd.inventory_item_id, SUM(wrd.Primary_quantity) quantity,
4598: wrd.organization_id,wrd.primary_uom
4599: FROM WMS_REPLENISHMENT_DETAILS wrd, wsh_delivery_details wdd
4600: WHERE wrd.demand_line_detail_id = wdd.delivery_detail_id
4601: AND wrd.demand_line_id = wdd.source_line_id
4602: AND wrd.organization_id = P_ORG_ID
4603: AND wrd.organization_id = wdd.organization_id

Line 4623: FROM WMS_REPLENISHMENT_DETAILS WRD

4619:
4620:
4621: CURSOR c_demands_for_mo(p_org_id NUMBER, p_mo_header_id NUMBER, p_mo_line_id NUMBER) IS
4622: SELECT demand_line_detail_id, demand_line_id
4623: FROM WMS_REPLENISHMENT_DETAILS WRD
4624: WHERE WRD.organization_id = P_ORG_ID
4625: AND WRD.source_header_id = P_mo_header_id
4626: AND WRD.Source_line_id = P_mo_line_id;
4627: BEGIN

Line 4945: -- BULK INSERT ALL consumed demands IN wms_replenishment_details table

4941: IF (l_debug = 1) THEN
4942: print_debug('BULK INSERT ALL CONSUMED DEMANDS IN WRD table' );
4943: END IF;
4944:
4945: -- BULK INSERT ALL consumed demands IN wms_replenishment_details table
4946: FORALL k IN INDICES OF l_demand_line_detail_id_tab
4947: INSERT INTO WMS_REPLENISHMENT_DETAILS
4948: (Replenishment_id,
4949: Organization_Id,

Line 4947: INSERT INTO WMS_REPLENISHMENT_DETAILS

4943: END IF;
4944:
4945: -- BULK INSERT ALL consumed demands IN wms_replenishment_details table
4946: FORALL k IN INDICES OF l_demand_line_detail_id_tab
4947: INSERT INTO WMS_REPLENISHMENT_DETAILS
4948: (Replenishment_id,
4949: Organization_Id,
4950: source_header_id,
4951: Source_line_id,

Line 4970: WMS_REPLENISHMENT_DETAILS_S.NEXTVAL,

4966: CREATED_BY,
4967: LAST_UPDATED_BY,
4968: LAST_UPDATE_LOGIN
4969: )VALUES (
4970: WMS_REPLENISHMENT_DETAILS_S.NEXTVAL,
4971: l_organization_id_tab(k),
4972: l_mo_header_id_tab(k),
4973: l_mo_line_id_tab(k),
4974: NULL,

Line 6633: from WMS_REPLENISHMENT_DETAILS wrd

6629: and MR.SUBINVENTORY_CODE IS NOT NULL --locator is not needed
6630: and (nvl(mr.staged_flag,'N') = 'N' and nvl(mr.detailed_quantity,0) = 0)) --13398141 ; Exclude detailed RSV
6631: AND NOT EXISTS
6632: (select wrd.demand_line_detail_id
6633: from WMS_REPLENISHMENT_DETAILS wrd
6634: where wrd.demand_line_detail_id = wdd.delivery_detail_id
6635: and wrd.demand_line_id = wdd.source_line_id
6636: and wrd.organization_id = wdd.organization_id
6637: AND wrd.organization_id = p_org_id)

Line 7647: UPDATE WMS_REPLENISHMENT_DETAILS

7643:
7644: IF P_PRIMARY_QUANTITY > 0 THEN
7645: --UPDATE THE PRIMARY QTY FOR THE DEMAND
7646:
7647: UPDATE WMS_REPLENISHMENT_DETAILS
7648: SET PRIMARY_QUANTITY = P_PRIMARY_QUANTITY
7649: WHERE DEMAND_LINE_DETAIL_ID = p_delivery_detail_id
7650: AND primary_quantity >= P_PRIMARY_QUANTITY;
7651:

Line 7659: DELETE FROM WMS_REPLENISHMENT_DETAILS

7655: -- In this case we will have More qty in the replenishment mover
7656: -- ORDER that will be consumed BY later processing
7657:
7658:
7659: DELETE FROM WMS_REPLENISHMENT_DETAILS
7660: WHERE DEMAND_LINE_DETAIL_ID = P_DELIVERY_DETAIL_ID;
7661:
7662: END IF;
7663:

Line 7685: FROM WMS_REPLENISHMENT_DETAILS

7681: INTO l_source_header_id,l_Source_line_id,
7682: l_Source_line_detail_id, l_Source_type_id,
7683: l_demand_header_id,l_demand_line_id, l_demand_type_id,l_Primary_UOM, l_orig_pri_qty, l_demand_sort_order,
7684: l_item_id, l_org_id , l_repl_level, l_repl_type
7685: FROM WMS_REPLENISHMENT_DETAILS
7686: WHERE DEMAND_LINE_DETAIL_ID = p_delivery_detail_id;
7687: EXCEPTION
7688: WHEN no_data_found THEN
7689: l_orig_pri_qty := -9999;

Line 7698: UPDATE WMS_REPLENISHMENT_DETAILS

7694: -- detail id is found IN WRD
7695: IF (NOT l_no_deliv_in_wrd) AND l_orig_pri_qty <> -9999 AND p_primary_quantity < l_orig_pri_qty THEN
7696:
7697: -- Update old delivery with decreased qty
7698: UPDATE WMS_REPLENISHMENT_DETAILS
7699: SET PRIMARY_QUANTITY = P_PRIMARY_QUANTITY
7700: WHERE DEMAND_LINE_DETAIL_ID = p_delivery_detail_id;
7701:
7702: -- Insert a new record in WRD with remaining qty

Line 7705: INSERT INTO WMS_REPLENISHMENT_DETAILS

7701:
7702: -- Insert a new record in WRD with remaining qty
7703: -- Note: Priority of the Split demand Order remain same as the
7704: -- original one
7705: INSERT INTO WMS_REPLENISHMENT_DETAILS
7706: (Replenishment_id,
7707: Organization_Id,
7708: source_header_id,
7709: Source_line_id,

Line 7728: WMS_REPLENISHMENT_DETAILS_S.NEXTVAL,

7724: CREATED_BY,
7725: LAST_UPDATED_BY,
7726: LAST_UPDATE_LOGIN
7727: )VALUES (
7728: WMS_REPLENISHMENT_DETAILS_S.NEXTVAL,
7729: l_org_id,
7730: l_source_header_id,
7731: l_source_line_id,
7732: l_Source_line_detail_id,