DBA Data[Home] [Help]

APPS.CSP_PLANNER_NOTIFICATIONS dependencies on MTL_RELATED_ITEMS_VIEW

Line 239: FROM mtl_related_items_view

235: WHERE organization_id = p_organization_id;
236:
237: CURSOR supercess_items_cur(p_item_id NUMBER) IS
238: SELECT inventory_item_id
239: FROM mtl_related_items_view
240: WHERE relationship_type_id = 18
241: AND related_item_id = p_item_id;
242:
243: l_item_attr_rec item_attr_cur%ROWTYPE;

Line 1081: FROM mtl_related_items_view

1077: -- check to see if item can be repaired to itself
1078: begin
1079: SELECT related_item_id
1080: INTO l_related_item
1081: FROM mtl_related_items_view
1082: WHERE relationship_type_id = 18
1083: AND inventory_item_id = onc.inventory_item_id;
1084: exception
1085: when NO_DATA_FOUND then