APPS.OZF_QP_QUAL_PVT dependencies on OZF_RESALE_LINES_ALL

Line 1915: FROM ozf_resale_lines_all

1911:
1912: CURSOR c_resale_line_info(p_resale_line_id IN NUMBER) IS
1913: SELECT inventory_item_id,org_id, supplier_item_cost,
1914: nvl(supplier_item_uom,uom_code), currency_code
1915: FROM ozf_resale_lines_all
1916: WHERE resale_line_id = p_resale_line_id;
1917:
1918: CURSOR c_iface_line_info(p_resale_line_int_id IN NUMBER) IS
1919: SELECT inventory_item_id,org_id, supplier_item_cost,

Line 1973: 3) If its is iface store in ozf_resale_lines_int_all, if its resale store in ozf_resale_lines_all.

1969: If not provided during batch upload then get using costing API and store in this column.
1970:
1971: 2.2) If both are diff then get using costing API and store in column Supplier Item Cost.
1972:
1973: 3) If its is iface store in ozf_resale_lines_int_all, if its resale store in ozf_resale_lines_all.
1974:
1975: 4) If exception happens or costing API doesn't return anything then store -1 in respective columns.
1976: */
1977:

Line 1989: l_qry_str := 'UPDATE ozf_resale_lines_all SET supplier_item_cost = :1 WHERE resale_line_id = :2 AND supplier_item_cost IS NULL' ;

1985: END IF;
1986:
1987: CASE
1988: WHEN l_resale_table_type = 'RESALE' THEN
1989: l_qry_str := 'UPDATE ozf_resale_lines_all SET supplier_item_cost = :1 WHERE resale_line_id = :2 AND supplier_item_cost IS NULL' ;
1990:
1991: --derive resale order information like organization_id, item_id, uom etc.
1992:
1993: OPEN c_resale_line_info(p_line_id);