DBA Data[Home] [Help]

APPS.OZF_AR_INTERFACE_PVT dependencies on FND_PROFILE

Line 1153: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');

1149: CURSOR csr_product_desc(cv_inventory_item_id IN NUMBER) IS
1150: SELECT SUBSTRB(description, 1, 240)
1151: FROM mtl_system_items_vl
1152: WHERE inventory_item_id = cv_inventory_item_id
1153: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
1154:
1155: CURSOR csr_offer_name(cv_claim_line_id IN NUMBER)IS
1156: SELECT SUBSTR(offer_code,1,50)
1157: FROM ozf_offers offer, ozf_claim_lines_all line