APPS.OZF_SD_REQUEST_PUB dependencies on OZF_SUPP_TRD_PRFLS_ALL

Line 486: FROM ozf_supp_trd_prfls_all

482: CURSOR c_authorization_period(p_supplier_id IN NUMBER,
483: p_supplier_site_id IN NUMBER,
484: p_org_id IN NUMBER)IS
485: SELECT NVL(authorization_period,-1)
486: FROM ozf_supp_trd_prfls_all
487: WHERE supplier_id = p_supplier_id
488: AND supplier_site_id = p_supplier_site_id
489: AND org_id = p_org_id;
490:

Line 1088: FROM ozf_supp_trd_prfls_all otrpf

1084: CURSOR c_cost_basis(p_supplier_id IN NUMBER
1085: ,p_supplier_site_id IN NUMBER
1086: ,p_org_id IN NUMBER)IS
1087: SELECT claim_computation_basis
1088: FROM ozf_supp_trd_prfls_all otrpf
1089: WHERE supplier_id = p_supplier_id
1090: AND supplier_site_id = p_supplier_site_id
1091: AND org_id = p_org_id;
1092:

Line 1097: FROM ozf_supp_trd_prfls_all

1093: CURSOR c_qty_increase_tolerance(p_supplier_id IN NUMBER
1094: ,p_supplier_site_id IN NUMBER
1095: ,p_org_id IN NUMBER)IS
1096: SELECT NVL(qty_increase_tolerance,0)
1097: FROM ozf_supp_trd_prfls_all
1098: WHERE supplier_id = p_supplier_id
1099: AND supplier_site_id = p_supplier_site_id
1100: AND org_id = p_org_id;
1101:

Line 1113: ozf_supp_trd_prfls_all trd_profile

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
1117: AND trd_profile.supplier_site_id = p_supplier_site_id

Line 1128: ozf_supp_trd_prfls_all trd_profile

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
1132: AND trd_profile.supplier_site_id = p_supplier_site_id

Line 3430: FROM ozf_supp_trd_prfls_all

3426: WHERE user_status_id = p_user_status_id;
3427:
3428: CURSOR c_communication(p_supplier_id IN NUMBER,p_supplier_site_id IN NUMBER)IS
3429: SELECT request_communication
3430: FROM ozf_supp_trd_prfls_all
3431: WHERE supplier_id =p_supplier_id
3432: AND supplier_site_id =p_supplier_site_id;
3433:
3434: CURSOR c_qp_list_header_id(p_request_header_id IN NUMBER)IS

Line 4574: FROM ozf_supp_trd_prfls_all

4570: CURSOR c_authorization_period(p_supplier_id IN NUMBER,
4571: p_supplier_site_id IN NUMBER,
4572: p_org_id IN NUMBER)IS
4573: SELECT NVL(authorization_period,-1)
4574: FROM ozf_supp_trd_prfls_all
4575: WHERE supplier_id = p_supplier_id
4576: AND supplier_site_id = p_supplier_site_id
4577: AND org_id = p_org_id;
4578: