APPS.DPP_UTILITY_PVT dependencies on OZF_SUPP_CODE_CONVERSIONS_ALL

Line 655: ozf_supp_code_conversions_all occ

651: msi.description,
652: occ.external_code
653: FROM mtl_system_items_kfv msi,
654: financials_system_params_all fspa,
655: ozf_supp_code_conversions_all occ
656: WHERE occ.internal_code = to_char(msi.inventory_item_id)
657: AND occ.code_conversion_type = 'OZF_PRODUCT_CODES'
658: AND occ.supp_trade_profile_id = p_supp_trade_profile_id
659: AND occ.org_id = fspa.org_id

Line 692: FROM ozf_supp_code_conversions_all occ

688: AND p_search_criteria1 = 'ORG_ID'
689: AND p_search_criteria2 = 'ITEM_NUMBER'
690: AND UPPER(msi.concatenated_segments) LIKE UPPER(p_search_text2)
691: AND NOT EXISTS (SELECT 1
692: FROM ozf_supp_code_conversions_all occ
693: WHERE occ.internal_code = to_char(msi.inventory_item_id)
694: AND occ.code_conversion_type = 'OZF_PRODUCT_CODES'
695: AND occ.supp_trade_profile_id = p_supp_trade_profile_id
696: AND occ.org_id = to_number(p_search_text1)

Line 763: FROM ozf_supp_code_conversions_all

759:
760: BEGIN
761: SELECT count(*)
762: INTO l_supp_item_count
763: FROM ozf_supp_code_conversions_all
764: WHERE supp_trade_profile_id = l_supp_trade_profile_id;
765:
766: END;
767:

Line 773: FROM ozf_supp_code_conversions_all

769:
770: BEGIN
771: SELECT count(*)
772: INTO l_supp_item_count
773: FROM ozf_supp_code_conversions_all
774: WHERE supp_trade_profile_id = l_supp_trade_profile_id;
775:
776: END;
777: