DBA Data[Home] [Help]

APPS.CSP_PLAN_DETAILS_PKG dependencies on DUAL

Line 3172: from dual

3168: and cpr.organization_id(+) = msib.organization_id
3169: and cpr.inventory_item_id(+) = msib.inventory_item_id
3170: and msib.inventory_item_id in
3171: (select l_inventory_item_id
3172: from dual
3173: union
3174: select distinct cpd2.inventory_item_id
3175: from csp_plan_details cpd2
3176: where cpd2.plan_detail_type in ('1000','2000')