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_ITEM_SUBSTITUTES

Line 1998: MSC_ITEM_SUBSTITUTES mis

1994: Update MSC_SUPPLIES set releasable=9999 where transaction_id in
1995: (Select ms.transaction_id
1996: from MSC_SUPPLIES ms,
1997: MSC_PQ_RESULTS mpr,
1998: MSC_ITEM_SUBSTITUTES mis
1999: ,MSC_PLAN_QUERIES mpq,
2000: MSC_PERSONAL_QUERIES mpers
2001: where mpr.plan_id = pPlan_id
2002: and (mis.lower_item_id = mpr.inventory_item_id OR mis.higher_item_id = mpr.inventory_item_id)

Line 2025: MSC_ITEM_SUBSTITUTES mis

2021: Update MSC_SUPPLIES set releasable=9999 where transaction_id in
2022: (Select ms.transaction_id
2023: from MSC_SUPPLIES ms,
2024: MSC_PQ_RESULTS mpr,
2025: MSC_ITEM_SUBSTITUTES mis
2026: ,MSC_PLAN_QUERIES mpq,
2027: MSC_PERSONAL_QUERIES mpers
2028: where mpr.plan_id = pPlan_id
2029: and (mis.lower_item_id = mpr.inventory_item_id OR mis.higher_item_id = mpr.inventory_item_id)

Line 2116: MSC_ITEM_SUBSTITUTES mis

2112: ( Select ms.transaction_id
2113: from MSC_SUPPLIES ms,
2114: MSC_PQ_RESULTS mpr,
2115: MSC_EXCEPTION_DETAILS med,
2116: MSC_ITEM_SUBSTITUTES mis
2117: ,MSC_PLAN_QUERIES mpq,
2118: MSC_PERSONAL_QUERIES mpers
2119: where mpr.plan_id = pPlan_id
2120: and mpr.query_id =Mpq.Query_id

Line 2150: MSC_ITEM_SUBSTITUTES mis

2146: (Select ms.transaction_id
2147: from MSC_SUPPLIES ms,
2148: MSC_PQ_RESULTS mpr,
2149: MSC_EXCEPTION_DETAILS med,
2150: MSC_ITEM_SUBSTITUTES mis
2151: ,MSC_PLAN_QUERIES mpq,
2152: MSC_PERSONAL_QUERIES mpers
2153: where mpr.plan_id = pPlan_id
2154: and mpr.query_id =Mpq.Query_id

Line 2284: MSC_ITEM_SUBSTITUTES mis

2280: (Select ms.transaction_id
2281: from MSC_SUPPLIES ms,
2282: MSC_PQ_RESULTS mpr,
2283: MSC_SUPPLIES ms2,
2284: MSC_ITEM_SUBSTITUTES mis
2285: ,MSC_PLAN_QUERIES mpq,
2286: MSC_PERSONAL_QUERIES mpers
2287: where mpr.plan_id = pPlan_id
2288: and mpr.SOURCE_TABLE = 'MSC_SUPPLIES'

Line 2312: MSC_ITEM_SUBSTITUTES mis

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
2316: and mpr.SOURCE_TABLE = 'MSC_DEMANDS'

Line 2344: MSC_ITEM_SUBSTITUTES mis

2340: (Select ms.transaction_id
2341: from MSC_SUPPLIES ms,
2342: MSC_PQ_RESULTS mpr,
2343: MSC_SUPPLIES ms2,
2344: MSC_ITEM_SUBSTITUTES mis
2345: ,MSC_PLAN_QUERIES mpq,
2346: MSC_PERSONAL_QUERIES mpers
2347: where mpr.plan_id = pPlan_id
2348: and mpr.SOURCE_TABLE = 'MSC_SUPPLIES'

Line 2373: MSC_ITEM_SUBSTITUTES mis

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
2377: and mpr.SOURCE_TABLE = 'MSC_DEMANDS'

Line 2489: MSC_ITEM_SUBSTITUTES mis,

2485: Update MSC_SUPPLIES set releasable=9999 where transaction_id in
2486: ( select ms.transaction_id
2487: from MSC_SUPPLIES ms,
2488: MSC_PQ_RESULTS mpr,
2489: MSC_ITEM_SUBSTITUTES mis,
2490: --MSC_SUPPLIES ms2
2491: MSC_ITEM_SUPPLIERS ms2
2492: ,MSC_PLAN_QUERIES mpq,
2493: MSC_PERSONAL_QUERIES mpers

Line 2521: MSC_ITEM_SUBSTITUTES mis,

2517: Update MSC_SUPPLIES set releasable=9999 where transaction_id in
2518: (select ms.transaction_id
2519: from MSC_SUPPLIES ms,
2520: MSC_PQ_RESULTS mpr,
2521: MSC_ITEM_SUBSTITUTES mis,
2522: --MSC_SUPPLIES ms2
2523: MSC_ITEM_SUPPLIERS ms2
2524: ,MSC_PLAN_QUERIES mpq,
2525: MSC_PERSONAL_QUERIES mpers