APPS.AMS_ITEM_OWNER_PVT dependencies on AMS_ITEM_ATTRIBUTES

Line 110: FROM ams_item_attributes

106:
107: CURSOR get_object_id(l_inv_id NUMBER)
108: IS
109: SELECT item_owner_id
110: FROM ams_item_attributes
111: WHERE inventory_item_id = l_inv_id
112: AND is_master_item='Y';
113:
114:

Line 511: From AMS_ITEM_ATTRIBUTES

507: STATUS_CODE,
508: EFFECTIVE_DATE,
509: IS_MASTER_ITEM,
510: ITEM_SETUP_TYPE
511: From AMS_ITEM_ATTRIBUTES
512: WHERE ITEM_OWNER_ID = l_ITEM_OWNER_ID; -- item owner id is the PK for am item attributes table
513:
514:
515: Cursor C_check_INV_or_OMO_item ( l_inv_id IN NUMBER, l_org_id IN NUMBER) IS

Line 517: FROM ams_item_attributes

513:
514:
515: Cursor C_check_INV_or_OMO_item ( l_inv_id IN NUMBER, l_org_id IN NUMBER) IS
516: SELECT count(*)
517: FROM ams_item_attributes
518: WHERE inventory_item_id = l_inv_id
519: AND organization_id = l_org_id;
520:
521: item_count NUMBER;

Line 583: -- ams item attributes

579: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
580: END IF;
581: -- check whether item is OMO or INV item
582: -- if INV item set IS_OMO_ITEM = Y and check whenever updating
583: -- ams item attributes
584:
585: OPEN C_check_INV_or_OMO_item(p_item_rec_in.INVENTORY_ITEM_ID, p_item_rec_in.ORGANIZATION_ID);
586: FETCH C_check_INV_or_OMO_item INTO item_count;
587: if (item_count > 0 ) then

Line 1103: FROM ams_item_ATTRIBUTES

1099: IS
1100:
1101: CURSOR c_ITEM_OWNER IS
1102: SELECT *
1103: FROM ams_item_ATTRIBUTES
1104: WHERE ITEM_OWNER_ID = p_ITEM_OWNER_Rec.ITEM_OWNER_ID;
1105:
1106: l_ITEM_OWNER_Rec_Type c_ITEM_OWNER%ROWTYPE;
1107: