APPS.OZF_SUPP_TRADE_PROFILE_PUB dependencies on FND_PROFILE

Line 661: WHERE (organization_id = FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID'))

657:
658: CURSOR csr_get_item(cv_item_number varchar2) IS
659: SELECT inventory_item_id
660: FROM mtl_system_items_vl
661: WHERE (organization_id = FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID'))
662: AND ENABLED_FLAG = 'Y'
663: AND fnd_date.canonical_to_date(sysdate) BETWEEN fnd_date.canonical_to_date(NVL(START_DATE_ACTIVE,sysdate))
664: AND fnd_date.canonical_to_date(NVL(END_DATE_ACTIVE,sysdate))
665: AND concatenated_segments = cv_item_number ;