APPS.OZF_OM_VALIDATION_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 1277: FROM ra_customer_trx_all

1273: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1274:
1275: CURSOR csr_order_reference(cv_customer_trx_id IN NUMBER) IS
1276: SELECT interface_header_context
1277: FROM ra_customer_trx_all
1278: WHERE customer_trx_id = cv_customer_trx_id;
1279:
1280: CURSOR csr_ord_total_quantity(cv_header_id IN NUMBER) IS
1281: SELECT ordered_quantity

Line 1296: FROM ra_customer_trx_all

1292: AND line_category_code = 'RETURN';
1293:
1294: CURSOR csr_inv_ord_number(cv_cust_id IN NUMBER) IS
1295: SELECT interface_header_attribute1
1296: FROM ra_customer_trx_all
1297: WHERE customer_trx_id = cv_cust_id;
1298:
1299: CURSOR csr_inv_header_id(cv_customer_trx IN NUMBER) IS
1300: SELECT header_id