APPS.AMS_REL_ITEM_PVT dependencies on MTL_RELATED_ITEMS

Line 67: From MTL_RELATED_ITEMS

63: REQUEST_ID,
64: PROGRAM_APPLICATION_ID,
65: PROGRAM_ID,
66: PROGRAM_UPDATE_DATE
67: From MTL_RELATED_ITEMS
68: WHERE inventory_item_id = P_REL_ITEM_Rec.inventory_item_id
69: AND organization_id = P_REL_ITEM_Rec.organization_id
70: AND related_item_id = P_REL_ITEM_Rec.related_item_id
71: AND relationship_type_id = P_REL_ITEM_Rec.relationship_type_id;

Line 330: From MTL_RELATED_ITEMS

326: REQUEST_ID,
327: PROGRAM_APPLICATION_ID,
328: PROGRAM_ID,
329: PROGRAM_UPDATE_DATE
330: From MTL_RELATED_ITEMS
331: WHERE inventory_item_id = P_REL_ITEM_Rec.inventory_item_id
332: AND organization_id = P_REL_ITEM_Rec.organization_id
333: AND related_item_id = P_REL_ITEM_Rec.related_item_id
334: AND relationship_type_id = P_REL_ITEM_Rec.relationship_type_id;

Line 537: FROM mtl_related_items

533: l_item_owner_id NUMBER;
534:
535: Cursor check_item is
536: SELECT 1
537: FROM mtl_related_items
538: WHERE organization_id = P_REL_ITEM_Rec.organization_id
539: AND inventory_item_id = p_REL_ITEM_Rec.inventory_item_id;
540: --AND related_item_id = P_REL_ITEM_Rec.related_item_id
541: --AND relationship_type_id = P_REL_ITEM_Rec.relationship_type_id;

Line 740: FROM mtl_related_items

736:
737:
738: CURSOR c_rel_item_rec IS
739: SELECT *
740: FROM mtl_related_items
741: WHERE inventory_item_id = P_REL_ITEM_Rec.inventory_item_id
742: AND organization_id = P_REL_ITEM_Rec.organization_id
743: AND related_item_id = P_REL_ITEM_Rec.related_item_id
744: AND relationship_type_id = P_REL_ITEM_Rec.relationship_type_id;