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_RELEASE_PK dependencies on MSC_DEMANDS

Line 557: msc_demands md,

553: --and (ms.releasable =0 or ms.releasable is null)
554: and ms.batch_id is null
555: and
556: not exists (select 1 from msc_full_pegging mfp,
557: msc_demands md,
558: msc_supplies ms1
559: where mfp.sr_instance_id = ms.sr_instance_id and
560: mfp.plan_id = ms.plan_id and
561: mfp.transaction_id =ms.transaction_id and

Line 1222: FROM msc_demands

1218: BEGIN
1219: var_sales_order_line_id := NULL;
1220: SELECT sales_order_line_id
1221: INTO var_sales_order_line_id
1222: FROM msc_demands
1223: WHERE
1224: plan_id = var_plan_id
1225: AND sr_instance_id = var_sr_instance_id
1226: AND disposition_id = var_transaction_id

Line 2206: MSC_DEMANDS md

2202: union all
2203: Select ms.transaction_id
2204: from MSC_SUPPLIES ms,
2205: MSC_PQ_RESULTS mpr,
2206: MSC_DEMANDS md
2207: ,MSC_PLAN_QUERIES mpq,
2208: MSC_PERSONAL_QUERIES mpers
2209: where mpr.plan_id = pPlan_id
2210: and mpr.SOURCE_TABLE = 'MSC_DEMANDS'

Line 2210: and mpr.SOURCE_TABLE = 'MSC_DEMANDS'

2206: MSC_DEMANDS md
2207: ,MSC_PLAN_QUERIES mpq,
2208: MSC_PERSONAL_QUERIES mpers
2209: where mpr.plan_id = pPlan_id
2210: and mpr.SOURCE_TABLE = 'MSC_DEMANDS'
2211: and md.ROWID = mpr.row_id
2212: and mpr.plan_id= md.plan_id
2213: and ms.plan_id= md.plan_id
2214: and ms.sr_instance_id = md.sr_instance_id

Line 2255: MSC_DEMANDS md

2251: union all
2252: Select ms.transaction_id
2253: from MSC_SUPPLIES ms,
2254: MSC_PQ_RESULTS mpr,
2255: MSC_DEMANDS md
2256: ,MSC_PLAN_QUERIES mpq,
2257: MSC_PERSONAL_QUERIES mpers
2258: where mpr.plan_id = pPlan_id
2259: and mpr.SOURCE_TABLE = 'MSC_DEMANDS'

Line 2259: and mpr.SOURCE_TABLE = 'MSC_DEMANDS'

2255: MSC_DEMANDS md
2256: ,MSC_PLAN_QUERIES mpq,
2257: MSC_PERSONAL_QUERIES mpers
2258: where mpr.plan_id = pPlan_id
2259: and mpr.SOURCE_TABLE = 'MSC_DEMANDS'
2260: and md.ROWID = mpr.row_id
2261: and mpr.plan_id= md.plan_id
2262: and mpr.sr_instance_id= md.sr_instance_id
2263: and ms.plan_id= md.plan_id

Line 2311: MSC_DEMANDS md,

2307: union all
2308: Select ms.transaction_id
2309: from MSC_SUPPLIES ms,
2310: MSC_PQ_RESULTS mpr,
2311: MSC_DEMANDS md,
2312: MSC_ITEM_SUBSTITUTES mis
2313: ,MSC_PLAN_QUERIES mpq,
2314: MSC_PERSONAL_QUERIES mpers
2315: where mpr.plan_id = pPlan_id

Line 2316: and mpr.SOURCE_TABLE = 'MSC_DEMANDS'

2312: MSC_ITEM_SUBSTITUTES mis
2313: ,MSC_PLAN_QUERIES mpq,
2314: MSC_PERSONAL_QUERIES mpers
2315: where mpr.plan_id = pPlan_id
2316: and mpr.SOURCE_TABLE = 'MSC_DEMANDS'
2317: and md.ROWID = mpr.row_id
2318: and mpr.plan_id= md.plan_id
2319: and mpr.sr_instance_id= md.sr_instance_id
2320: and ( md.inventory_item_id = mis.lower_item_id OR md.inventory_item_id = mis.higher_item_id )

Line 2372: MSC_DEMANDS md,

2368: union all
2369: Select ms.transaction_id
2370: from MSC_SUPPLIES ms,
2371: MSC_PQ_RESULTS mpr,
2372: MSC_DEMANDS md,
2373: MSC_ITEM_SUBSTITUTES mis
2374: ,MSC_PLAN_QUERIES mpq,
2375: MSC_PERSONAL_QUERIES mpers
2376: where mpr.plan_id = pPlan_id

Line 2377: and mpr.SOURCE_TABLE = 'MSC_DEMANDS'

2373: MSC_ITEM_SUBSTITUTES mis
2374: ,MSC_PLAN_QUERIES mpq,
2375: MSC_PERSONAL_QUERIES mpers
2376: where mpr.plan_id = pPlan_id
2377: and mpr.SOURCE_TABLE = 'MSC_DEMANDS'
2378: and md.ROWID = mpr.row_id
2379: and mpr.plan_id= md.plan_id
2380: and mpr.sr_instance_id= md.sr_instance_id
2381: and ( md.inventory_item_id = mis.lower_item_id OR md.inventory_item_id = mis.higher_item_id )