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.MSC_CL_PUBLISH dependencies on MSC_SUP_DEM_ENTRIES_S

Line 201: select --msc_sup_dem_entries_s.nextval transaction_id

197:
198: CURSOR mscSupply(p_refresh_number NUMBER,
199: p_sr_instance_id NUMBER,
200: p_language_code VARCHAR2) IS
201: select --msc_sup_dem_entries_s.nextval transaction_id
202: G_SR_INSTANCE_ID sr_instance_id
203: ,G_PLAN_ID plan_id
204: ,decode(ms.order_type, 11, mcr.object_id , G_OEM_ID) publisher_id -- Bug 4395985
205: ,decode(ms.order_type, 11, mtpm1.company_key , mcsil.company_site_id) publisher_site_id

Line 1556: -- msc_sup_dem_entries_s.nextval TRANSACTION_ID,

1552: p_sr_instance_id NUMBER,
1553: p_language_code VARCHAR2) IS
1554:
1555: select
1556: -- msc_sup_dem_entries_s.nextval TRANSACTION_ID,
1557: G_PLAN_ID PLAN_ID,
1558: G_SR_INSTANCE_ID SR_INSTANCE_ID,
1559: G_OEM_ID PUBLISHER_ID,
1560: mcs.company_site_id PUBLISHER_SITE_ID,

Line 1707: -- msc_sup_dem_entries_s.nextval TRANSACTION_ID,

1703: and nvl(mso.reservation_type, -99) = 1
1704: and mso.demand_source_type <> 8 /* Ignore Internal Sales orders */
1705: UNION /* sales order in supplier modeled orgs (multi company plng) */
1706: select
1707: -- msc_sup_dem_entries_s.nextval TRANSACTION_ID,
1708: G_PLAN_ID PLAN_ID,
1709: G_SR_INSTANCE_ID SR_INSTANCE_ID,
1710: G_OEM_ID PUBLISHER_ID,
1711: mcs_org.company_site_id PUBLISHER_SITE_ID,

Line 2178: l_supplier_item_name MSC_SUP_DEM_ENTRIES.SUPPLIER_ITEM_NAME%TYPE;

2174: a_resultant_update number_arr := number_arr();
2175:
2176: l_owner_item_name MSC_SUP_DEM_ENTRIES.OWNER_ITEM_NAME%TYPE;
2177: l_customer_item_name MSC_SUP_DEM_ENTRIES.CUSTOMER_ITEM_NAME%TYPE;
2178: l_supplier_item_name MSC_SUP_DEM_ENTRIES.SUPPLIER_ITEM_NAME%TYPE;
2179: l_owner_item_desc MSC_SUP_DEM_ENTRIES.OWNER_ITEM_DESCRIPTION%TYPE;
2180: l_customer_item_desc MSC_SUP_DEM_ENTRIES.CUSTOMER_ITEM_DESCRIPTION%TYPE;
2181: l_supplier_item_desc MSC_SUP_DEM_ENTRIES.SUPPLIER_ITEM_DESCRIPTION%TYPE;
2182: l_lead_time NUMBER;

Line 2181: l_supplier_item_desc MSC_SUP_DEM_ENTRIES.SUPPLIER_ITEM_DESCRIPTION%TYPE;

2177: l_customer_item_name MSC_SUP_DEM_ENTRIES.CUSTOMER_ITEM_NAME%TYPE;
2178: l_supplier_item_name MSC_SUP_DEM_ENTRIES.SUPPLIER_ITEM_NAME%TYPE;
2179: l_owner_item_desc MSC_SUP_DEM_ENTRIES.OWNER_ITEM_DESCRIPTION%TYPE;
2180: l_customer_item_desc MSC_SUP_DEM_ENTRIES.CUSTOMER_ITEM_DESCRIPTION%TYPE;
2181: l_supplier_item_desc MSC_SUP_DEM_ENTRIES.SUPPLIER_ITEM_DESCRIPTION%TYPE;
2182: l_lead_time NUMBER;
2183: l_tp_customer_id NUMBER;
2184: l_tp_customer_site_id NUMBER;
2185: l_location_id NUMBER;

Line 3111: msc_sup_dem_entries_s.nextval,

3107: ,planner_code --Bug 4424426
3108: )values
3109: (
3110: t_ins_sr_instance_id(j),
3111: msc_sup_dem_entries_s.nextval,
3112: --t_ins_transaction_id(j),
3113: t_ins_plan_id(j),
3114: t_ins_pub_id(j),
3115: t_ins_pub_site_id(j),

Line 3507: ( msc_sup_dem_entries_s.nextval,

3503: base_item_name,
3504: planner_code--Bug 4424426
3505: )
3506: values
3507: ( msc_sup_dem_entries_s.nextval,
3508: t_ins_plan_id(i),
3509: t_ins_sr_instance_id(i),
3510: t_ins_pub_id(i),
3511: t_ins_pub_site_id(i),

Line 4117: ( msc_sup_dem_entries_s.nextval,

4113: , base_item_name
4114: ,planner_code --Bug 4424426
4115: )
4116: values
4117: ( msc_sup_dem_entries_s.nextval,
4118: t_ins_plan_id(i),
4119: t_ins_sr_instance_id(i),
4120: t_ins_pub_id(i),
4121: t_ins_pub_site_id(i),

Line 4639: msc_sup_dem_entries_s.nextval,

4635: planner_code --Bug 4424426
4636: )
4637: values
4638: (
4639: msc_sup_dem_entries_s.nextval,
4640: t_ins_plan_id(i) ,
4641: t_ins_sr_instance_id(i),
4642: t_ins_pub_id(i) ,
4643: t_ins_pub_site_id(i) ,

Line 4718: update msc_sup_dem_entries sd

4714: BEGIN
4715:
4716: FORALL i in 1..t_plan_id.COUNT
4717:
4718: update msc_sup_dem_entries sd
4719: set link_trans_id = t_line_num(i)
4720: where sd.plan_id = G_PLAN_ID
4721: and sd.sr_instance_id = G_SR_INSTANCE_ID
4722: and sd.inventory_item_id = t_item_id(i)

Line 5802: msc_sup_dem_entries_s.nextval,

5798: ,planner_code--Bug 4424426
5799: )values
5800: (
5801: G_SR_INSTANCE_ID,
5802: msc_sup_dem_entries_s.nextval,
5803: G_PLAN_ID,
5804: t_ins_pub_id(j),
5805: t_ins_pub_site_id(j),
5806: t_ins_pub(j),

Line 5885: update msc_sup_dem_entries sd

5881: LOG_MESSAGE('updating pegging info for int reqs using ASN.');
5882:
5883: FORALL i in 1..t_pub_id.COUNT
5884:
5885: update msc_sup_dem_entries sd
5886: set link_trans_id = t_delivery_id(i)
5887: where sd.plan_id = G_PLAN_ID
5888: and sd.sr_instance_id = G_SR_INSTANCE_ID
5889: and sd.inventory_item_id = t_item_id(i)