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_PLAN_QUERIES

Line 1918: MSC_PLAN_QUERIES mpq,

1914: lv_inc_rescheds NUMBER ;
1915: V_TAB V_TAB_TYPE;
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)

Line 1953: MSC_PLAN_QUERIES mpq,

1949: Update MSC_SUPPLIES set releasable=9999 where transaction_id in
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

Line 1975: MSC_PLAN_QUERIES mpq,

1971: Update MSC_SUPPLIES set releasable=9999 where transaction_id in
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

Line 1999: ,MSC_PLAN_QUERIES mpq,

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

Line 2026: ,MSC_PLAN_QUERIES mpq,

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

Line 2056: ,MSC_PLAN_QUERIES mpq,

2052: (Select ms.transaction_id
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

Line 2085: ,MSC_PLAN_QUERIES mpq,

2081: ( Select ms.transaction_id
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

Line 2117: ,MSC_PLAN_QUERIES mpq,

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

Line 2151: ,MSC_PLAN_QUERIES mpq,

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

Line 2187: ,MSC_PLAN_QUERIES mpq,

2183: (Select ms.transaction_id
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

Line 2207: ,MSC_PLAN_QUERIES mpq,

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

Line 2233: ,MSC_PLAN_QUERIES mpq,

2229: (Select ms.transaction_id
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

Line 2256: ,MSC_PLAN_QUERIES mpq,

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

Line 2285: ,MSC_PLAN_QUERIES mpq,

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

Line 2313: ,MSC_PLAN_QUERIES mpq,

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

Line 2345: ,MSC_PLAN_QUERIES mpq,

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

Line 2374: ,MSC_PLAN_QUERIES mpq,

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

Line 2406: ,MSC_PLAN_QUERIES mpq,

2402: Update MSC_SUPPLIES set releasable=9999 where transaction_id in
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

Line 2433: ,MSC_PLAN_QUERIES mpq,

2429: from MSC_SUPPLIES ms,
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

Line 2461: ,MSC_PLAN_QUERIES mpq,

2457: from MSC_SUPPLIES ms,
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

Line 2492: ,MSC_PLAN_QUERIES mpq,

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
2494: where mpr.plan_id = pPlan_id
2495: and mpr.query_id =Mpq.Query_id
2496: And ms2.plan_id = mpr.plan_id

Line 2524: ,MSC_PLAN_QUERIES mpq,

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
2526: where mpr.plan_id = pPlan_id
2527: and mpr.query_id =Mpq.Query_id
2528: And ms2.plan_id = mpr.plan_id