DBA Data[Home] [Help]

APPS.OZF_SD_REQUEST_PUB dependencies on OZF_SUPP_CODE_CONVERSIONS_ALL

Line 1346: FROM ozf_supp_code_conversions_all code,

1342: ,p_supplier_site_id IN NUMBER
1343: ,p_org_id IN NUMBER
1344: ,p_inventory_item_id IN NUMBER)IS
1345: SELECT external_code
1346: FROM ozf_supp_code_conversions_all code,
1347: ozf_supp_trd_prfls_all trd_profile
1348: WHERE code.code_conversion_type = 'OZF_PRODUCT_CODES'
1349: AND code.supp_trade_profile_id = trd_profile.supp_trade_profile_id
1350: AND trd_profile.supplier_id = p_supplier_id

Line 1361: FROM ozf_supp_code_conversions_all code,

1357: ,p_supplier_site_id IN NUMBER
1358: ,p_org_id IN NUMBER) IS
1359: SELECT external_code, --Vendor Item Code
1360: internal_code --Inventory Item ID
1361: FROM ozf_supp_code_conversions_all code,
1362: ozf_supp_trd_prfls_all trd_profile
1363: WHERE code.code_conversion_type = 'OZF_PRODUCT_CODES'
1364: AND code.supp_trade_profile_id = trd_profile.supp_trade_profile_id
1365: AND trd_profile.supplier_id = p_supplier_id