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_REL_PS_PLAN_PUB dependencies on MSC_BOM_COMPONENTS

Line 3402: msc_bom_components subcomp,

3398: s.implement_uom_code, -- bugbug again should fall back to sys_items?
3399: s.sr_instance_id
3400: FROM msc_trading_partners tp,
3401: msc_item_id_lid sr_item,
3402: msc_bom_components subcomp,
3403: msc_component_substitutes bsub,
3404: /* msc_bom_components bcomp, */
3405: msc_item_id_lid icomp,
3406: msc_demands md,

Line 3404: /* msc_bom_components bcomp, */

3400: FROM msc_trading_partners tp,
3401: msc_item_id_lid sr_item,
3402: msc_bom_components subcomp,
3403: msc_component_substitutes bsub,
3404: /* msc_bom_components bcomp, */
3405: msc_item_id_lid icomp,
3406: msc_demands md,
3407: msc_supplies s
3408:

Line 4568: NVL(md.wip_supply_type, msi.wip_supply_type), -- rthyagar, we should take from msc_bom_components as second priority later

4564: decode(md.component_scaling_type,1,NULL,md.component_scaling_type),
4565: TO_NUMBER(NULL), --decode(l_apps_ver,'4',TO_NUMBER(NULL),'3',TO_NUMBER(NULL),(md.USING_REQUIREMENT_QUANTITY/s.implement_quantity)),
4566: TO_NUMBER(NULL), --md.component_yield_factor, -- bugbug is this correct?
4567: TO_NUMBER(NULL), --Department_ID
4568: NVL(md.wip_supply_type, msi.wip_supply_type), -- rthyagar, we should take from msc_bom_components as second priority later
4569: md.USING_ASSEMBLY_DEMAND_DATE,
4570: TO_NUMBER(NULL), --decode(l_apps_ver,'4',TO_NUMBER(NULL),'3',TO_NUMBER(NULL),md.USING_REQUIREMENT_QUANTITY),
4571: TO_NUMBER(NULL), --quantity_issued
4572: TO_CHAR(NULL), -- Sub Inventory

Line 4780: msc_bom_components subcomp,

4776: s.implement_uom_code, -- bugbug again should fall back to sys_items?
4777: s.sr_instance_id
4778: FROM msc_trading_partners tp,
4779: msc_item_id_lid sr_item,
4780: msc_bom_components subcomp,
4781: msc_component_substitutes bsub,
4782: /* msc_bom_components bcomp, */
4783: msc_item_id_lid icomp,
4784: msc_demands md,

Line 4782: /* msc_bom_components bcomp, */

4778: FROM msc_trading_partners tp,
4779: msc_item_id_lid sr_item,
4780: msc_bom_components subcomp,
4781: msc_component_substitutes bsub,
4782: /* msc_bom_components bcomp, */
4783: msc_item_id_lid icomp,
4784: msc_demands md,
4785: msc_supplies s
4786: