[Home] [Help]
38: -- sup_dem_entries currently
39:
40: select NVL(max(last_refresh_number), 0)
41: into l_curr_max_refresh_number
42: from msc_sup_dem_entries
43: where plan_id = -1;
44:
45: print_user_info(' Current maximum refresh number = ' || l_curr_max_refresh_number);
46:
81:
82:
83: BEGIN
84: -- get the next replenishment transaction id
85: SELECT msc_sup_dem_entries_s.nextval
86: INTO l_rep_transaction_id FROM DUAL;
87:
88:
89: vmi_replenish(l_last_max_refresh_number,
291: /*----------------------------------------+
292: | Get the new replenishment tranaction id |
293: +-----------------------------------------*/
294:
295: SELECT msc_sup_dem_entries_s.nextval
296: INTO l_rep_transaction_id FROM DUAL;
297:
298:
299: if(l_repl_row_found = SYS_NO) then
303: print_debug_info(' before insert replenishment record, transaction ID = '
304: || l_rep_transaction_id
305: );
306:
307: INSERT INTO msc_sup_dem_entries
308: (
309: transaction_id
310: , plan_id
311: , sr_instance_id
456: );
457:
458: /* update repl row */
459:
460: UPDATE msc_sup_dem_entries sd
461: SET
462: transaction_id = l_rep_transaction_id
463: , uom_code = l_uom_code
464: , quantity = l_order_quantity
560: print_debug_info(' before delete replenishment record = '
561: || l_rep_transaction_id
562: );
563:
564: DELETE FROM msc_sup_dem_entries sd
565: WHERE sd.publisher_id = OEM_COMPANY_ID
566: AND sd.inventory_item_id = l_item_id
567: AND sd.publisher_order_type = REPLENISHMENT
568: AND sd.plan_id = CP_PLAN_ID
836: msc_companies customer,
837: msc_company_sites customer_site,
838: msc_companies oem,
839: msc_system_items msi,
840: msc_sup_dem_entries sup_dem,
841: msc_sup_dem_entries sd,
842: msc_trading_partners mtp,
843: msc_trading_partner_maps map1,
844: msc_trading_partner_maps map2,
837: msc_company_sites customer_site,
838: msc_companies oem,
839: msc_system_items msi,
840: msc_sup_dem_entries sup_dem,
841: msc_sup_dem_entries sd,
842: msc_trading_partners mtp,
843: msc_trading_partner_maps map1,
844: msc_trading_partner_maps map2,
845: msc_company_relationships mcr
995: AND msi.sr_instance_id = mtp.sr_instance_id
996: AND msi.organization_id = mtp.sr_tp_id
997: AND msi.plan_id = CP_PLAN_ID
998: AND 0 = (select count(*) from
999: msc_sup_dem_entries txns
1000: where txns.inventory_item_id = msi.inventory_item_id
1001: and txns.plan_id = msi.plan_id
1002: and DECODE(txns.publisher_order_type,
1003: UNALLOCATED_ONHAND, txns.publisher_id,
1513:
1514: print_debug_info(' Start of procedure vmi_reject');
1515: -- change the release status of the replenishment record from
1516: -- from UNRELEASED to REJECTED
1517: UPDATE msc_sup_dem_entries sd
1518: SET release_status = REJECTED
1519: WHERE sd.transaction_id = l_rep_transaction_id
1520: ;
1521:
1691: || '/' || p_consigned_flag
1692: || '/' || p_vmi_release_type
1693: );
1694:
1695: SELECT msc_sup_dem_entries_s.nextval
1696: INTO l_rep_transaction_id FROM DUAL;
1697: -- use item id, supplier id, customer id, customer site id, replenishment
1698: -- transaction id to compose a Workflow key, this Workflow key will be used
1699: -- by UI code to release the replenishment
2039: , nvl(mvt.average_daily_demand, 0)
2040: , mtp.partner_name
2041: FROM
2042: msc_system_items msi,
2043: msc_sup_dem_entries sd,
2044: msc_trading_partners mtp,
2045: msc_trading_partner_maps map1,
2046: msc_trading_partner_maps map2,
2047: msc_company_relationships mcr
2242: , sd.publisher_order_type_desc
2243:
2244: FROM
2245: msc_system_items msi,
2246: msc_sup_dem_entries sd,
2247: msc_trading_partners mtp,
2248: msc_trading_partner_maps map1,
2249: msc_trading_partner_maps map2,
2250: msc_company_relationships mcr
2308: , mtp.partner_name
2309: , sd.publisher_order_type_desc
2310: FROM
2311: msc_system_items msi,
2312: msc_sup_dem_entries sd,
2313: msc_trading_partners mtp,
2314: msc_trading_partner_maps map1,
2315: msc_trading_partner_maps map2,
2316: msc_company_relationships mcr