DBA Data[Home] [Help]

APPS.OZF_AR_INTERFACE_PVT dependencies on FND_PROFILE

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

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