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 482: from WMS_REPLENISHMENT_DETAILS wrd

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

Line 2142: from WMS_REPLENISHMENT_DETAILS wrd

2138: AND party_id = nvl(p_customer_id,party_id)))
2139: AND wdd.source_header_type_id = nvl(P_ORDER_TYPE_ID,source_header_type_id)
2140: AND NOT exists
2141: (select wrd.demand_line_detail_id
2142: from WMS_REPLENISHMENT_DETAILS wrd
2143: where wrd.demand_line_detail_id = wdd.delivery_detail_id
2144: and wrd.demand_line_id = wdd.source_line_id
2145: and wrd.organization_id = wdd.organization_id
2146: And wrd.organization_id = p_organization_id)

Line 2627: FROM wms_replenishment_details

2623: IF l_repl_level IS NULL THEN
2624: BEGIN
2625: SELECT repl_level
2626: INTO l_repl_level
2627: FROM wms_replenishment_details
2628: WHERE source_type_id = 4
2629: AND organization_id = p_organization_id
2630: AND inventory_item_id = p_inventory_item_id
2631: AND source_header_id = p_move_order_header_id

Line 3864: INSERT INTO wms_replenishment_details

3860: END IF;
3861:
3862: -- BULK UPLOAD ALL DEMAND RECORDS IN THE WRD TABLE
3863: FORALL k in 1 .. l_demand_line_detail_id_tab.COUNT()
3864: INSERT INTO wms_replenishment_details
3865: (Replenishment_id,
3866: Organization_id,
3867: source_header_id,
3868: Source_line_id,

Line 3887: WMS_REPLENISHMENT_DETAILS_S.NEXTVAL,

3883: CREATED_BY,
3884: LAST_UPDATED_BY,
3885: LAST_UPDATE_LOGIN
3886: )VALUES (
3887: WMS_REPLENISHMENT_DETAILS_S.NEXTVAL,
3888: l_organization_id_tab(k),
3889: l_mo_header_id_tab(k),
3890: l_mo_line_id_tab(k),
3891: NULL,

Line 3951: INSERT INTO wms_replenishment_details

3947: inv_cache.item_rec.primary_uom_code)),
3948: g_conversion_precision);
3949:
3950:
3951: INSERT INTO wms_replenishment_details
3952: (Replenishment_id,
3953: Organization_id,
3954: source_header_id,
3955: Source_line_id,

Line 3975: WMS_REPLENISHMENT_DETAILS_S.NEXTVAL, --Replenishment_id,

3971: LAST_UPDATED_BY,
3972: LAST_UPDATE_LOGIN
3973: )
3974: SELECT
3975: WMS_REPLENISHMENT_DETAILS_S.NEXTVAL, --Replenishment_id,
3976: p_consol_item_repl_tbl(i).organization_id, --Organization_id,
3977: l_x_trolin_tbl(1).header_id, -- source_header_id,
3978: l_x_trolin_tbl(1).line_id, -- Source_line_id,
3979: NULL, -- Source_line_detail_id,

Line 4434: from WMS_REPLENISHMENT_DETAILS wrd

4430: and mtrl.line_status in (3, 7) -- only approved and pre-approved
4431: and mtrh.move_order_type = 2 -- for replenishment only
4432: AND not exists
4433: (select WRD.Source_line_id
4434: from WMS_REPLENISHMENT_DETAILS wrd
4435: where WRD.source_header_id = MTRL.HEADER_ID
4436: AND WRD.Source_line_id = MTRL.LINE_ID
4437: And wrd.organization_id = mtrl.organization_id
4438: And wrd.organization_id = p_org_id )

Line 4457: FROM WMS_REPLENISHMENT_DETAILS wrd, wsh_delivery_details wdd

4453: (
4454: SELECT WRD.Source_line_id, WRD.source_header_id,
4455: wrd.inventory_item_id, SUM(wrd.Primary_quantity) quantity,
4456: wrd.organization_id,wrd.primary_uom
4457: FROM WMS_REPLENISHMENT_DETAILS wrd, wsh_delivery_details wdd
4458: WHERE wrd.demand_line_detail_id = wdd.delivery_detail_id
4459: AND wrd.demand_line_id = wdd.source_line_id
4460: AND wrd.organization_id = P_ORG_ID
4461: AND wrd.organization_id = wdd.organization_id

Line 4481: FROM WMS_REPLENISHMENT_DETAILS WRD

4477:
4478:
4479: CURSOR c_demands_for_mo(p_org_id NUMBER, p_mo_header_id NUMBER, p_mo_line_id NUMBER) IS
4480: SELECT demand_line_detail_id, demand_line_id
4481: FROM WMS_REPLENISHMENT_DETAILS WRD
4482: WHERE WRD.organization_id = P_ORG_ID
4483: AND WRD.source_header_id = P_mo_header_id
4484: AND WRD.Source_line_id = P_mo_line_id;
4485: BEGIN

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

4775: IF (l_debug = 1) THEN
4776: print_debug('BULK INSERT ALL CONSUMED DEMANDS IN WRD table' );
4777: END IF;
4778:
4779: -- BULK INSERT ALL consumed demands IN wms_replenishment_details table
4780: FORALL k IN INDICES OF l_demand_line_detail_id_tab
4781: INSERT INTO WMS_REPLENISHMENT_DETAILS
4782: (Replenishment_id,
4783: Organization_Id,

Line 4781: INSERT INTO WMS_REPLENISHMENT_DETAILS

4777: END IF;
4778:
4779: -- BULK INSERT ALL consumed demands IN wms_replenishment_details table
4780: FORALL k IN INDICES OF l_demand_line_detail_id_tab
4781: INSERT INTO WMS_REPLENISHMENT_DETAILS
4782: (Replenishment_id,
4783: Organization_Id,
4784: source_header_id,
4785: Source_line_id,

Line 4804: WMS_REPLENISHMENT_DETAILS_S.NEXTVAL,

4800: CREATED_BY,
4801: LAST_UPDATED_BY,
4802: LAST_UPDATE_LOGIN
4803: )VALUES (
4804: WMS_REPLENISHMENT_DETAILS_S.NEXTVAL,
4805: l_organization_id_tab(k),
4806: l_mo_header_id_tab(k),
4807: l_mo_line_id_tab(k),
4808: NULL,

Line 6461: from WMS_REPLENISHMENT_DETAILS wrd

6457: decode(wdd.source_document_type_id, 10, 8, 2)
6458: and MR.SUBINVENTORY_CODE IS NOT NULL) --locator is not needed -- Exclude detailed RSV
6459: AND NOT EXISTS
6460: (select wrd.demand_line_detail_id
6461: from WMS_REPLENISHMENT_DETAILS wrd
6462: where wrd.demand_line_detail_id = wdd.delivery_detail_id
6463: and wrd.demand_line_id = wdd.source_line_id
6464: and wrd.organization_id = wdd.organization_id
6465: AND wrd.organization_id = p_org_id)

Line 7472: UPDATE WMS_REPLENISHMENT_DETAILS

7468:
7469: IF P_PRIMARY_QUANTITY > 0 THEN
7470: --UPDATE THE PRIMARY QTY FOR THE DEMAND
7471:
7472: UPDATE WMS_REPLENISHMENT_DETAILS
7473: SET PRIMARY_QUANTITY = P_PRIMARY_QUANTITY
7474: WHERE DEMAND_LINE_DETAIL_ID = p_delivery_detail_id
7475: AND primary_quantity >= P_PRIMARY_QUANTITY;
7476:

Line 7484: DELETE FROM WMS_REPLENISHMENT_DETAILS

7480: -- In this case we will have More qty in the replenishment mover
7481: -- ORDER that will be consumed BY later processing
7482:
7483:
7484: DELETE FROM WMS_REPLENISHMENT_DETAILS
7485: WHERE DEMAND_LINE_DETAIL_ID = P_DELIVERY_DETAIL_ID;
7486:
7487: END IF;
7488:

Line 7510: FROM WMS_REPLENISHMENT_DETAILS

7506: INTO l_source_header_id,l_Source_line_id,
7507: l_Source_line_detail_id, l_Source_type_id,
7508: l_demand_header_id,l_demand_line_id, l_demand_type_id,l_Primary_UOM, l_orig_pri_qty, l_demand_sort_order,
7509: l_item_id, l_org_id , l_repl_level, l_repl_type
7510: FROM WMS_REPLENISHMENT_DETAILS
7511: WHERE DEMAND_LINE_DETAIL_ID = p_delivery_detail_id;
7512: EXCEPTION
7513: WHEN no_data_found THEN
7514: l_orig_pri_qty := -9999;

Line 7523: UPDATE WMS_REPLENISHMENT_DETAILS

7519: -- detail id is found IN WRD
7520: IF (NOT l_no_deliv_in_wrd) AND l_orig_pri_qty <> -9999 AND p_primary_quantity < l_orig_pri_qty THEN
7521:
7522: -- Update old delivery with decreased qty
7523: UPDATE WMS_REPLENISHMENT_DETAILS
7524: SET PRIMARY_QUANTITY = P_PRIMARY_QUANTITY
7525: WHERE DEMAND_LINE_DETAIL_ID = p_delivery_detail_id;
7526:
7527: -- Insert a new record in WRD with remaining qty

Line 7530: INSERT INTO WMS_REPLENISHMENT_DETAILS

7526:
7527: -- Insert a new record in WRD with remaining qty
7528: -- Note: Priority of the Split demand Order remain same as the
7529: -- original one
7530: INSERT INTO WMS_REPLENISHMENT_DETAILS
7531: (Replenishment_id,
7532: Organization_Id,
7533: source_header_id,
7534: Source_line_id,

Line 7553: WMS_REPLENISHMENT_DETAILS_S.NEXTVAL,

7549: CREATED_BY,
7550: LAST_UPDATED_BY,
7551: LAST_UPDATE_LOGIN
7552: )VALUES (
7553: WMS_REPLENISHMENT_DETAILS_S.NEXTVAL,
7554: l_org_id,
7555: l_source_header_id,
7556: l_source_line_id,
7557: l_Source_line_detail_id,