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.BOM_ATO_NEW_ATP_PK dependencies on MTL_DEMAND

Line 33: the rows that have been deactivated in mtl_demand by the Schedule

29: begin
30:
31: /*---------------------------------------------------------------+
32: We need to inform ATP to modify demand (quanatity zero) for
33: the rows that have been deactivated in mtl_demand by the Schedule
34: function, as part of 'link Config' action
35: +----------------------------------------------------------------*/
36: select inventory_item_id,
37: organization_id,

Line 97: from mtl_demand md

93: p_atp_table.Vendor_Site_Id ,
94: p_atp_table.Insert_Flag ,
95: p_atp_table.Error_Code ,
96: p_atp_table.Message
97: from mtl_demand md
98: where md.RTO_MODEL_SOURCE_LINE = RTOMLine
99: and md.demand_source_header_id = dSrcHdrId
100: and md.demand_source_type = dSrcType
101: and md.organization_id = OrgId

Line 110: in mtl_demand by the Schedule function, as part of

106:
107: /*---------------------------------------------------------------+
108: We also need to inform ATP to add demand (quanatity zero) for
109: the mandatory components that have been inserted (derived demand)
110: in mtl_demand by the Schedule function, as part of
111: 'link Config' action
112: +----------------------------------------------------------------*/
113:
114: select inventory_item_id,

Line 175: from mtl_demand md

171: p_atp_table.Vendor_Site_Id ,
172: p_atp_table.Insert_Flag ,
173: p_atp_table.Error_Code ,
174: p_atp_table.Message
175: from mtl_demand md
176: where md.RTO_MODEL_SOURCE_LINE = RTOMLine
177: and md.DEMAND_SOURCE_HEADER_ID = dSrcHdrId
178: and md.DEMAND_SOURCE_TYPE = dSrcType
179: and md.ORGANIZATION_ID = OrgId

Line 250: the mandatory components (derived demand) in mtl_demand

246:
247:
248: /*---------------------------------------------------------------+
249: We need to inform ATP to modify demand (quanatity zero) for
250: the mandatory components (derived demand) in mtl_demand
251: that will be deleted by the Schedule function, as part of
252: 'delink Config' action
253: +----------------------------------------------------------------*/
254: stmt := 10;

Line 316: from mtl_demand md

312: p_atp_table.Vendor_Site_Id ,
313: p_atp_table.Insert_Flag ,
314: p_atp_table.Error_Code ,
315: p_atp_table.Message
316: from mtl_demand md
317: where md.RTO_MODEL_SOURCE_LINE = RTOMLine
318: and md.demand_source_header_id = dSrcHdrId
319: and md.demand_source_type = dSrcType
320: and md.organization_id = OrgId

Line 329: the model components rows in mtl_demand that will be re-activated

325: and md.demand_type in (4,5);
326:
327: /*---------------------------------------------------------------+
328: We also need to inform ATP to add demand for
329: the model components rows in mtl_demand that will be re-activated
330: by the schedule function, as part of 'delink Config' action
331: +----------------------------------------------------------------*/
332:
333: select inventory_item_id,

Line 394: from mtl_demand md

390: p_atp_table.Vendor_Site_Id ,
391: p_atp_table.Insert_Flag ,
392: p_atp_table.Error_Code ,
393: p_atp_table.Message
394: from mtl_demand md
395: where md.rto_model_source_line = RTOMLine
396: and md.demand_source_header_id = dSrcHdrId
397: and md.demand_source_type = dSrcType
398: and md.organization_id = orgId