DBA Data[Home] [Help]

APPS.OZF_SD_REQUEST_PUB dependencies on OZF_SUPP_CODE_CONVERSIONS_ALL

Line 1112: FROM ozf_supp_code_conversions_all code,

1108: ,p_supplier_site_id IN NUMBER
1109: ,p_org_id IN NUMBER
1110: ,p_inventory_item_id IN NUMBER)IS
1111: SELECT external_code
1112: FROM ozf_supp_code_conversions_all code,
1113: ozf_supp_trd_prfls_all trd_profile
1114: WHERE code.code_conversion_type = 'OZF_PRODUCT_CODES'
1115: AND code.supp_trade_profile_id = trd_profile.supp_trade_profile_id
1116: AND trd_profile.supplier_id = p_supplier_id

Line 1127: FROM ozf_supp_code_conversions_all code,

1123: ,p_supplier_site_id IN NUMBER
1124: ,p_org_id IN NUMBER) IS
1125: SELECT external_code, --Vendor Item Code
1126: internal_code --Inventory Item ID
1127: FROM ozf_supp_code_conversions_all code,
1128: ozf_supp_trd_prfls_all trd_profile
1129: WHERE code.code_conversion_type = 'OZF_PRODUCT_CODES'
1130: AND code.supp_trade_profile_id = trd_profile.supp_trade_profile_id
1131: AND trd_profile.supplier_id = p_supplier_id