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

Line 363: ** Update MTL_DEMAND for the children to inherit the

359: ** and b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
360: */
361:
362: /*
363: ** Update MTL_DEMAND for the children to inherit the
364: ** operation_seq_num of their parents.This works
365: ** for all levels. This is executed only if the
366: ** BOM:CONFIG_INHERIT_OP_SEQ profile option is set to YES
367: */

Line 371: table_name := 'MTL_DEMAND';

367: */
368:
369: IF inherit_check = 1 THEN
370:
371: table_name := 'MTL_DEMAND';
372:
373: /* Initialize the bom_level columns to NULL */
374:
375: stmt_num := 30;

Line 376: update mtl_demand

372:
373: /* Initialize the bom_level columns to NULL */
374:
375: stmt_num := 30;
376: update mtl_demand
377: set bom_level = NULL
378: where config_group_id = USERENV('SESSIONID');
379:
380: /* Here we are identifying the base model row and

Line 385: update mtl_demand

381: ** setting the bom_level to zero.
382: */
383:
384: stmt_num := 40;
385: update mtl_demand
386: set bom_level = 0
387: where config_group_id = USERENV('SESSIONID')
388: and demand_type = 1
389: and rto_model_source_line = demand_source_line

Line 403: update mtl_demand d0

399:
400: WHILE rowcount <> 0 LOOP
401:
402: stmt_num := 50;
403: update mtl_demand d0
404: set bom_level = bom_level_indicator + 1,
405: config_group_id = USERENV('SESSIONID'),
406: operation_seq_num =
407: (select distinct

Line 413: mtl_demand d2

409: 1,NVL(d2.operation_seq_num,bic2.operation_seq_num),
410: bic1.operation_seq_num)
411: from bom_inventory_components bic1, /*child */
412: bom_inventory_components bic2, /*parent */
413: mtl_demand d2
414: where bic1.component_sequence_id=d0.component_sequence_id
415: and bic2.component_sequence_id=d0.parent_component_seq_id
416: and d0.parent_component_seq_id=d2.component_sequence_id
417: and d0.rto_model_source_line = d2.rto_model_source_line

Line 422: from mtl_demand d1

418: and d2.primary_uom_quantity <>0
419: and d2.bom_level = bom_level_indicator)
420: where (d0.parent_component_seq_id, d0.rto_model_source_line)in
421: (select d1.component_sequence_id, d1.rto_model_source_line
422: from mtl_demand d1
423: where d1.config_group_id = USERENV('SESSIONID')
424: and d1.primary_uom_quantity <>0
425: and d1.bom_level = bom_level_indicator)
426: and d0.primary_uom_quantity <>0;

Line 576: mtl_demand d1, /Option /

572: ic1.supply_subinventory,
573: ic1.supply_locator_id
574: from
575: bom_inventory_components ic1,
576: mtl_demand d1, /*Option */
577: mtl_demand d2, /* Parent-Model */
578: mtl_demand d3, /* parent-Component */
579: bom_bill_of_mtls_interface b
580: where ic1.component_sequence_id =( /* Refer bug 625484. component_sequence_id */

Line 577: mtl_demand d2, /* Parent-Model */

573: ic1.supply_locator_id
574: from
575: bom_inventory_components ic1,
576: mtl_demand d1, /*Option */
577: mtl_demand d2, /* Parent-Model */
578: mtl_demand d3, /* parent-Component */
579: bom_bill_of_mtls_interface b
580: where ic1.component_sequence_id =( /* Refer bug 625484. component_sequence_id */
581: select component_sequence_id /* in d1 points to components in validation */

Line 578: mtl_demand d3, /* parent-Component */

574: from
575: bom_inventory_components ic1,
576: mtl_demand d1, /*Option */
577: mtl_demand d2, /* Parent-Model */
578: mtl_demand d3, /* parent-Component */
579: bom_bill_of_mtls_interface b
580: where ic1.component_sequence_id =( /* Refer bug 625484. component_sequence_id */
581: select component_sequence_id /* in d1 points to components in validation */
582: from bom_inventory_components bic /* so,we need to map these to Mfg org. For */

Line 751: mtl_demand d2, /* Model-Parent */

747: ic1.supply_subinventory,
748: ic1.supply_locator_id
749: from
750: bom_bill_of_mtls_interface b1,
751: mtl_demand d2, /* Model-Parent */
752: mtl_demand d1, /* Standard Mandatory comp */
753: mtl_system_items si1,
754: bom_bill_of_materials b,
755: bom_inventory_components ic1

Line 752: mtl_demand d1, /* Standard Mandatory comp */

748: ic1.supply_locator_id
749: from
750: bom_bill_of_mtls_interface b1,
751: mtl_demand d2, /* Model-Parent */
752: mtl_demand d1, /* Standard Mandatory comp */
753: mtl_system_items si1,
754: bom_bill_of_materials b,
755: bom_inventory_components ic1
756: where d1.organization_id = si1.organization_id

Line 920: mtl_demand d2, /* Model */

916: ic1.supply_subinventory,
917: ic1.supply_locator_id
918: from
919: bom_bill_of_mtls_interface b,
920: mtl_demand d2, /* Model */
921: mtl_demand d1, /* Option Classes */
922: mtl_demand d3, /* parent component */
923: bom_inventory_components ic1
924: where ic1.component_sequence_id =( /* See 625484 releated comments in stmt 60 */

Line 921: mtl_demand d1, /* Option Classes */

917: ic1.supply_locator_id
918: from
919: bom_bill_of_mtls_interface b,
920: mtl_demand d2, /* Model */
921: mtl_demand d1, /* Option Classes */
922: mtl_demand d3, /* parent component */
923: bom_inventory_components ic1
924: where ic1.component_sequence_id =( /* See 625484 releated comments in stmt 60 */
925: select component_sequence_id

Line 922: mtl_demand d3, /* parent component */

918: from
919: bom_bill_of_mtls_interface b,
920: mtl_demand d2, /* Model */
921: mtl_demand d1, /* Option Classes */
922: mtl_demand d3, /* parent component */
923: bom_inventory_components ic1
924: where ic1.component_sequence_id =( /* See 625484 releated comments in stmt 60 */
925: select component_sequence_id
926: from bom_inventory_components bic

Line 1086: mtl_demand d2,

1082: 0 /* This is an addition column
1083: to save the model component
1084: seq id for later use */
1085: from
1086: mtl_demand d2,
1087: bom_bill_of_mtls_interface b
1088: where d2.config_status = 20
1089: and d2.demand_source_line = b.demand_source_line
1090: and d2.demand_source_type = b.demand_source_type

Line 1200: MTL_DEMAND d,

1196: b.total_product_cycle_time,
1197: b.ctp_flag
1198: from
1199: BOM_OPERATIONAL_ROUTINGS b,
1200: MTL_DEMAND d,
1201: MTL_PARAMETERS mp,
1202: MTL_SYSTEM_ITEMS_INTERFACE m
1203: where m.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1204: and d.demand_source_line = m.demand_source_line

Line 1381: mtl_demand d2,/* Model for est. release date */

1377: total_time_user,
1378: Net_planning_percent
1379: from
1380: bom_op_routings_interface b1,
1381: mtl_demand d2,/* Model for est. release date */
1382: mtl_demand d1,
1383: mtl_system_items si1,
1384: bom_operational_routings or1,
1385: bom_operation_sequences os1

Line 1382: mtl_demand d1,

1378: Net_planning_percent
1379: from
1380: bom_op_routings_interface b1,
1381: mtl_demand d2,/* Model for est. release date */
1382: mtl_demand d1,
1383: mtl_system_items si1,
1384: bom_operational_routings or1,
1385: bom_operation_sequences os1
1386: where b1.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))

Line 1536: mtl_demand d2,/* Model for est. release date */

1532: total_time_user,
1533: Net_planning_percent
1534: from
1535: bom_op_routings_interface b1,
1536: mtl_demand d2,/* Model for est. release date */
1537: mtl_demand d1,
1538: mtl_system_items si1,
1539: bom_operational_routings or1,
1540: bom_operation_sequences os1

Line 1537: mtl_demand d1,

1533: Net_planning_percent
1534: from
1535: bom_op_routings_interface b1,
1536: mtl_demand d2,/* Model for est. release date */
1537: mtl_demand d1,
1538: mtl_system_items si1,
1539: bom_operational_routings or1,
1540: bom_operation_sequences os1
1541: where b1.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))

Line 1692: mtl_demand d1, /* components */

1688: total_time_user,
1689: Net_planning_percent
1690: from
1691: bom_op_routings_interface b,
1692: mtl_demand d1, /* components */
1693: mtl_demand d2, /* parents */
1694: mtl_demand d3, /* Model estd release date */
1695: bom_inventory_components ic1,
1696: bom_bill_of_materials b1,

Line 1693: mtl_demand d2, /* parents */

1689: Net_planning_percent
1690: from
1691: bom_op_routings_interface b,
1692: mtl_demand d1, /* components */
1693: mtl_demand d2, /* parents */
1694: mtl_demand d3, /* Model estd release date */
1695: bom_inventory_components ic1,
1696: bom_bill_of_materials b1,
1697: bom_operational_routings or1,

Line 1694: mtl_demand d3, /* Model estd release date */

1690: from
1691: bom_op_routings_interface b,
1692: mtl_demand d1, /* components */
1693: mtl_demand d2, /* parents */
1694: mtl_demand d3, /* Model estd release date */
1695: bom_inventory_components ic1,
1696: bom_bill_of_materials b1,
1697: bom_operational_routings or1,
1698: bom_operation_sequences os1

Line 1877: mtl_demand d2, /* Model if option class */

1873: mtl_system_items si2,
1874: bom_inventory_components ic1,
1875: bom_bill_of_materials b1,
1876: mtl_system_items si1,
1877: mtl_demand d2, /* Model if option class */
1878: mtl_demand d1, /* Model or option class */
1879: bom_op_routings_interface b
1880: where b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1881: and d1.rto_model_source_line = b.demand_source_line

Line 1878: mtl_demand d1, /* Model or option class */

1874: bom_inventory_components ic1,
1875: bom_bill_of_materials b1,
1876: mtl_system_items si1,
1877: mtl_demand d2, /* Model if option class */
1878: mtl_demand d1, /* Model or option class */
1879: bom_op_routings_interface b
1880: where b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1881: and d1.rto_model_source_line = b.demand_source_line
1882: and d1.config_status = 20

Line 2013: mtl_demand md,

2009: where operation_seq_num not in
2010: (select /o+ ORDERED o/
2011: s.operation_seq_num
2012: from
2013: mtl_demand md,
2014: mtl_system_items ms,
2015: bom_operational_routings r,
2016: bom_operation_sequences s,
2017: bom_op_routings_interface ri