APPS.DPP_UTILITY_PVT dependencies on OZF_SUPP_CODE_CONVERSIONS_ALL

Line 623: ozf_supp_code_conversions_all occ

619: msi.description,
620: occ.external_code
621: FROM mtl_system_items_kfv msi,
622: financials_system_params_all fspa,
623: ozf_supp_code_conversions_all occ
624: WHERE occ.internal_code = to_char(msi.inventory_item_id)
625: AND occ.code_conversion_type = 'OZF_PRODUCT_CODES'
626: AND occ.supp_trade_profile_id = p_supp_trade_profile_id
627: AND occ.org_id = fspa.org_id

Line 660: FROM ozf_supp_code_conversions_all occ

656: AND p_search_criteria1 = 'ORG_ID'
657: AND p_search_criteria2 = 'ITEM_NUMBER'
658: AND UPPER(msi.concatenated_segments) LIKE UPPER(p_search_text2) || '%'
659: AND NOT EXISTS (SELECT 1
660: FROM ozf_supp_code_conversions_all occ
661: WHERE occ.internal_code = to_char(msi.inventory_item_id)
662: AND occ.code_conversion_type = 'OZF_PRODUCT_CODES'
663: AND occ.supp_trade_profile_id = p_supp_trade_profile_id
664: AND occ.org_id = to_number(p_search_text1)

Line 725: FROM ozf_supp_code_conversions_all

721:
722: BEGIN
723: SELECT count(*)
724: INTO l_supp_item_count
725: FROM ozf_supp_code_conversions_all
726: WHERE supp_trade_profile_id = l_supp_trade_profile_id;
727:
728: END;
729:

Line 735: FROM ozf_supp_code_conversions_all

731:
732: BEGIN
733: SELECT count(*)
734: INTO l_supp_item_count
735: FROM ozf_supp_code_conversions_all
736: WHERE supp_trade_profile_id = l_supp_trade_profile_id;
737:
738: END;
739: