Line 860: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
856: CURSOR csr_prod_name(p_product_id IN NUMBER) IS
857: SELECT DESCRIPTION
858: FROM MTL_SYSTEM_ITEMS_KFV
859: WHERE INVENTORY_ITEM_ID = p_product_id 860: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID'); 861:
862: CURSOR csr_cust_name(cv_cust_account_id IN NUMBER) IS
863: SELECT CONCAT(CONCAT(party.party_name, ' ('), CONCAT(ca.account_number, ') '))
864: FROM hz_cust_accounts ca