APPS.MSC_X_CVMI_REPLENISH dependencies on MSC_SUP_DEM_ENTRIES_S

Line 85: SELECT msc_sup_dem_entries_s.nextval

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,

Line 295: SELECT msc_sup_dem_entries_s.nextval

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

Line 460: UPDATE msc_sup_dem_entries sd

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

Line 564: DELETE FROM msc_sup_dem_entries sd

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

Line 840: msc_sup_dem_entries sup_dem,

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,

Line 841: msc_sup_dem_entries sd,

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

Line 1505: UPDATE msc_sup_dem_entries sd

1501:
1502: print_debug_info(' Start of procedure vmi_reject');
1503: -- change the release status of the replenishment record from
1504: -- from UNRELEASED to REJECTED
1505: UPDATE msc_sup_dem_entries sd
1506: SET release_status = REJECTED
1507: WHERE sd.transaction_id = l_rep_transaction_id
1508: ;
1509:

Line 1683: SELECT msc_sup_dem_entries_s.nextval

1679: || '/' || p_consigned_flag
1680: || '/' || p_vmi_release_type
1681: );
1682:
1683: SELECT msc_sup_dem_entries_s.nextval
1684: INTO l_rep_transaction_id FROM DUAL;
1685: -- use item id, supplier id, customer id, customer site id, replenishment
1686: -- transaction id to compose a Workflow key, this Workflow key will be used
1687: -- by UI code to release the replenishment

Line 2031: msc_sup_dem_entries sd,

2027: , nvl(mvt.average_daily_demand, 0)
2028: , mtp.partner_name
2029: FROM
2030: msc_system_items msi,
2031: msc_sup_dem_entries sd,
2032: msc_trading_partners mtp,
2033: msc_trading_partner_maps map1,
2034: msc_trading_partner_maps map2,
2035: msc_company_relationships mcr

Line 2234: msc_sup_dem_entries sd,

2230: , sd.publisher_order_type_desc
2231:
2232: FROM
2233: msc_system_items msi,
2234: msc_sup_dem_entries sd,
2235: msc_trading_partners mtp,
2236: msc_trading_partner_maps map1,
2237: msc_trading_partner_maps map2,
2238: msc_company_relationships mcr

Line 2300: msc_sup_dem_entries sd,

2296: , mtp.partner_name
2297: , sd.publisher_order_type_desc
2298: FROM
2299: msc_system_items msi,
2300: msc_sup_dem_entries sd,
2301: msc_trading_partners mtp,
2302: msc_trading_partner_maps map1,
2303: msc_trading_partner_maps map2,
2304: msc_company_relationships mcr