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_PERSONAL_QUERIES

Line 1920: MSC_PERSONAL_QUERIES mpers

1916: Cursor queries is SELECT Distinct Mpers.query_type||' - '||Mpq.Applied_to
1917: FROM
1918: MSC_PLAN_QUERIES mpq,
1919: MSC_PQ_RESULTS mpr,
1920: MSC_PERSONAL_QUERIES mpers
1921: Where
1922: mpers.query_type in (1,4,5,9)
1923: AND mpq.plan_id = pPlan_id
1924: AND mpr.plan_id=mpq.plan_id

Line 1954: MSC_PERSONAL_QUERIES mpers

1950: ( select ms.transaction_id
1951: from MSC_SUPPLIES ms,
1952: MSC_PQ_RESULTS mpr,
1953: MSC_PLAN_QUERIES mpq,
1954: MSC_PERSONAL_QUERIES mpers
1955: where mpr.plan_id = pPlan_id
1956: and ms.plan_id = mpr.plan_id
1957: and ms.sr_instance_id = mpr.sr_instance_id
1958: and ms.inventory_item_id = mpr.inventory_item_id

Line 1976: MSC_PERSONAL_QUERIES mpers

1972: (Select ms.transaction_id
1973: from MSC_SUPPLIES ms,
1974: MSC_PQ_RESULTS mpr,
1975: MSC_PLAN_QUERIES mpq,
1976: MSC_PERSONAL_QUERIES mpers
1977: where mpr.plan_id = pPlan_id
1978: and ms.plan_id = mpr.plan_id
1979: and ms.sr_instance_id = mpr.sr_instance_id
1980: and ms.inventory_item_id = mpr.inventory_item_id

Line 2000: MSC_PERSONAL_QUERIES mpers

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)
2003: and mis.sr_instance_id = mpr.sr_instance_id
2004: and mis.plan_id = mpr.plan_id

Line 2027: MSC_PERSONAL_QUERIES mpers

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)
2030: and mis.sr_instance_id = mpr.sr_instance_id
2031: and mis.plan_id = mpr.plan_id

Line 2057: MSC_PERSONAL_QUERIES mpers

2053: from MSC_SUPPLIES ms,
2054: MSC_PQ_RESULTS mpr,
2055: MSC_EXCEPTION_DETAILS med
2056: ,MSC_PLAN_QUERIES mpq,
2057: MSC_PERSONAL_QUERIES mpers
2058: where mpr.plan_id = pPlan_id
2059: and mpr.query_id =Mpq.Query_id
2060: and mpr.summary_data =2
2061: and med.plan_id = mpr.plan_id

Line 2086: MSC_PERSONAL_QUERIES mpers

2082: from MSC_SUPPLIES ms,
2083: MSC_PQ_RESULTS mpr,
2084: MSC_EXCEPTION_DETAILS med
2085: ,MSC_PLAN_QUERIES mpq,
2086: MSC_PERSONAL_QUERIES mpers
2087: where mpr.plan_id = pPlan_id
2088: and mpr.query_id =Mpq.Query_id
2089: and mpr.summary_data =2
2090: and med.plan_id = mpr.plan_id

Line 2118: MSC_PERSONAL_QUERIES mpers

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
2121: and mpr.summary_data =2
2122: and med.plan_id = mpr.plan_id

Line 2152: MSC_PERSONAL_QUERIES mpers

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
2155: and mpr.summary_data =2
2156: and med.plan_id = mpr.plan_id

Line 2188: MSC_PERSONAL_QUERIES mpers

2184: from MSC_SUPPLIES ms,
2185: MSC_PQ_RESULTS mpr,
2186: MSC_SUPPLIES ms2
2187: ,MSC_PLAN_QUERIES mpq,
2188: MSC_PERSONAL_QUERIES mpers
2189: where mpr.plan_id = pPlan_id
2190: and mpr.SOURCE_TABLE = 'MSC_SUPPLIES'
2191: and ms2.ROWID = mpr.row_id
2192: and mpr.plan_id= ms2.plan_id

Line 2208: MSC_PERSONAL_QUERIES mpers

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'
2211: and md.ROWID = mpr.row_id
2212: and mpr.plan_id= md.plan_id

Line 2234: MSC_PERSONAL_QUERIES mpers

2230: from MSC_SUPPLIES ms,
2231: MSC_PQ_RESULTS mpr,
2232: MSC_SUPPLIES ms2
2233: ,MSC_PLAN_QUERIES mpq,
2234: MSC_PERSONAL_QUERIES mpers
2235: where mpr.plan_id = pPlan_id
2236: and mpr.SOURCE_TABLE = 'MSC_SUPPLIES'
2237: and ms2.ROWID = mpr.row_id
2238: and mpr.plan_id= ms2.plan_id

Line 2257: MSC_PERSONAL_QUERIES mpers

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'
2260: and md.ROWID = mpr.row_id
2261: and mpr.plan_id= md.plan_id

Line 2286: MSC_PERSONAL_QUERIES mpers

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'
2289: and ms2.ROWID = mpr.row_id
2290: and mpr.plan_id= ms2.plan_id

Line 2314: MSC_PERSONAL_QUERIES mpers

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'
2317: and md.ROWID = mpr.row_id
2318: and mpr.plan_id= md.plan_id

Line 2346: MSC_PERSONAL_QUERIES mpers

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'
2349: and ms2.ROWID = mpr.row_id
2350: and mpr.plan_id= ms2.plan_id

Line 2375: MSC_PERSONAL_QUERIES mpers

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'
2378: and md.ROWID = mpr.row_id
2379: and mpr.plan_id= md.plan_id

Line 2407: MSC_PERSONAL_QUERIES mpers

2403: (Select ms.transaction_id
2404: from MSC_SUPPLIES ms,
2405: MSC_PQ_RESULTS mpr
2406: ,MSC_PLAN_QUERIES mpq,
2407: MSC_PERSONAL_QUERIES mpers
2408: where mpr.plan_id = pPlan_id
2409: and mpr.SOURCE_TABLE = 'MSC_SUPPLIES'
2410: and ms.ROWID = mpr.row_id
2411: and mpr.plan_id= ms.plan_id

Line 2434: MSC_PERSONAL_QUERIES mpers

2430: MSC_PQ_RESULTS mpr,
2431: --MSC_SUPPLIES ms2
2432: MSC_ITEM_SUPPLIERS ms2
2433: ,MSC_PLAN_QUERIES mpq,
2434: MSC_PERSONAL_QUERIES mpers
2435: where mpr.plan_id = pPlan_id
2436: and ms2.plan_id=mpr.plan_id
2437: and ms2.sr_instance_id = mpr.sr_instance_id
2438: and ms2.inventory_item_id = mpr.inventory_item_id

Line 2462: MSC_PERSONAL_QUERIES mpers

2458: MSC_PQ_RESULTS mpr,
2459: --MSC_SUPPLIES ms2
2460: MSC_ITEM_SUPPLIERS ms2
2461: ,MSC_PLAN_QUERIES mpq,
2462: MSC_PERSONAL_QUERIES mpers
2463: where mpr.plan_id = pPlan_id
2464: and ms2.plan_id=mpr.plan_id
2465: and ms2.sr_instance_id = mpr.sr_instance_id
2466: and ms2.inventory_item_id = mpr.inventory_item_id

Line 2493: MSC_PERSONAL_QUERIES mpers

2489: MSC_ITEM_SUBSTITUTES mis,
2490: --MSC_SUPPLIES ms2
2491: MSC_ITEM_SUPPLIERS ms2
2492: ,MSC_PLAN_QUERIES mpq,
2493: MSC_PERSONAL_QUERIES mpers
2494: where mpr.plan_id = pPlan_id
2495: and mpr.query_id =Mpq.Query_id
2496: And ms2.plan_id = mpr.plan_id
2497: And ms2.sr_instance_id = mpr.sr_instance_id

Line 2525: MSC_PERSONAL_QUERIES mpers

2521: MSC_ITEM_SUBSTITUTES mis,
2522: --MSC_SUPPLIES ms2
2523: MSC_ITEM_SUPPLIERS ms2
2524: ,MSC_PLAN_QUERIES mpq,
2525: MSC_PERSONAL_QUERIES mpers
2526: where mpr.plan_id = pPlan_id
2527: and mpr.query_id =Mpq.Query_id
2528: And ms2.plan_id = mpr.plan_id
2529: And ms2.sr_instance_id = mpr.sr_instance_id