APPS.OZF_QP_QUAL_PVT dependencies on OZF_RESALE_BATCHES_ALL

Line 1926: FROM ozf_resale_lines_int_all orli, ozf_resale_batches_all orb

1922: WHERE resale_line_int_id = p_resale_line_int_id;
1923:
1924: CURSOR c_iface_batch_info(p_resale_line_int_id IN NUMBER) IS
1925: SELECT orb.direct_order_flag
1926: FROM ozf_resale_lines_int_all orli, ozf_resale_batches_all orb
1927: WHERE orli.resale_line_int_id = p_resale_line_int_id
1928: AND orb.resale_batch_id = orli.resale_batch_id;
1929:
1930: CURSOR c_resale_batch_info(p_resale_line_id IN NUMBER) IS

Line 1932: FROM ozf_resale_batches_all orb,

1928: AND orb.resale_batch_id = orli.resale_batch_id;
1929:
1930: CURSOR c_resale_batch_info(p_resale_line_id IN NUMBER) IS
1931: SELECT orb.direct_order_flag
1932: FROM ozf_resale_batches_all orb,
1933: ozf_resale_batch_line_maps_all orblm
1934: WHERE orblm.resale_line_id = p_resale_line_id
1935: AND orblm.resale_batch_id = orb.resale_batch_id;
1936:

Line 2009: /*Derive the value of direct_order_flag from ozf_resale_batches_all table

2005: OPEN c_exchange_rate_type_csr(l_organization_id);
2006: FETCH c_exchange_rate_type_csr INTO l_conversion_type_code;
2007: CLOSE c_exchange_rate_type_csr;
2008:
2009: /*Derive the value of direct_order_flag from ozf_resale_batches_all table
2010: IF yes then it's a direct order hence the purchase price should be provided
2011: during web-adi upload else set flag l_call_costing_api to true, so that
2012: purchase price can be derived later using costing API.*/
2013: