APPS.CSP_PART_SEARCH_PVT dependencies on MTL_RELATED_ITEMS

Line 1294: FROM mtl_related_items

1290: where organization_id = l_organization_id;
1291:
1292: cursor c_get_sup_items (v_inventory_item_id number, v_organization_id number, v_rel_type number) is
1293: SELECT related_item_id
1294: FROM mtl_related_items
1295: WHERE organization_id = v_organization_id
1296: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(start_date,sysdate)) AND TRUNC(NVL(end_date,sysdate))
1297: AND relationship_type_id = v_rel_type
1298: start with inventory_item_id = v_inventory_item_id

Line 1302: FROM mtl_related_items

1298: start with inventory_item_id = v_inventory_item_id
1299: CONNECT BY nocycle prior related_item_id = inventory_item_id
1300: UNION
1301: SELECT inventory_item_id AS related_item_id
1302: FROM mtl_related_items
1303: WHERE organization_id = v_organization_id
1304: AND relationship_type_id = v_rel_type
1305: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(start_date,sysdate)) AND TRUNC(NVL(end_date,sysdate))
1306: START WITH related_item_id = v_inventory_item_id

Line 1428: from mtl_related_items_view mriv,

1424: crpt.revision,
1425: mriv.related_item_id,
1426: crpt.quantity,
1427: 'SUBSTITUTE'
1428: from mtl_related_items_view mriv,
1429: mtl_parameters mp,
1430: csp_required_parts_temp crpt
1431: where mp.organization_id = l_organization_id
1432: and mriv.organization_id = mp.master_organization_id