DBA Data[Home] [Help]

APPS.MSC_RELEASE_PK dependencies on MSC_EXCEPTION_DETAILS

Line 2055: MSC_EXCEPTION_DETAILS med

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

Line 2084: MSC_EXCEPTION_DETAILS med

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

Line 2115: MSC_EXCEPTION_DETAILS med,

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

Line 2149: MSC_EXCEPTION_DETAILS med,

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