APPS.OZF_QP_QUAL_PVT dependencies on OE_ORDER_LINES_ALL

Line 1908: FROM oe_order_lines_all line, oe_order_headers_all head

1904: CURSOR c_order_info(p_order_line_id IN NUMBER) IS
1905: SELECT line.inventory_item_id, line.org_id,
1906: line.order_quantity_uom, head.transactional_curr_code,
1907: head.conversion_type_code, line.ship_from_org_id
1908: FROM oe_order_lines_all line, oe_order_headers_all head
1909: WHERE line.line_id = p_order_line_id
1910: AND line.header_id = head.header_id;
1911:
1912: CURSOR c_resale_line_info(p_resale_line_id IN NUMBER) IS

Line 1961: 1.2) Store cost price in oe_order_lines_all table. The column will be retreived from profile 'OZF: Store Item Cost'

1957:
1958: /*
1959: 1) For EBS OM orders
1960: 1.1) get cost price
1961: 1.2) Store cost price in oe_order_lines_all table. The column will be retreived from profile 'OZF: Store Item Cost'
1962: 1.3) Shouldn't we have a default value for this profile?
1963: 1.4) If any excpetion happens store -1 in this column
1964:
1965: 2) If resale_table_type is IFACE or RESALE then compare profile 'OZF: Use Indirect Sales as Order Source for Customer'

Line 2087: oe_order_lines_all where the calculated purchase price will be stored.

2083: END IF;
2084:
2085: /*FOR OM orders we have a new seeded profile at site and org level
2086: OZF: Store Item Cost. This profile will store the name of DFF column from
2087: oe_order_lines_all where the calculated purchase price will be stored.
2088: If profile is not set then raise FND warning*/
2089:
2090: IF l_column_name IS NOT NULL THEN
2091: l_qry_str := 'UPDATE oe_order_lines_all SET '|| l_column_name ||' = :1 WHERE line_id = :2 AND ' || l_column_name ||' IS NULL';

Line 2091: l_qry_str := 'UPDATE oe_order_lines_all SET '|| l_column_name ||' = :1 WHERE line_id = :2 AND ' || l_column_name ||' IS NULL';

2087: oe_order_lines_all where the calculated purchase price will be stored.
2088: If profile is not set then raise FND warning*/
2089:
2090: IF l_column_name IS NOT NULL THEN
2091: l_qry_str := 'UPDATE oe_order_lines_all SET '|| l_column_name ||' = :1 WHERE line_id = :2 AND ' || l_column_name ||' IS NULL';
2092: l_call_costing_api := true;
2093: ELSE
2094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
2095: FND_MESSAGE.set_name('OZF', 'OZF_PROFILE_MISS_WRG');

Line 2258: FROM oe_order_lines_all

2254: AND qualifier_attribute = p_qualifier_attribute;
2255:
2256: CURSOR c_account_type(p_order_line_id IN NUMBER) IS
2257: SELECT attribute3
2258: FROM oe_order_lines_all
2259: WHERE line_id = p_order_line_id;
2260:
2261: CURSOR c_item_vendor(p_order_line_id IN NUMBER) IS
2262: SELECT line.attribute4

Line 2263: FROM oe_order_lines_all line, mtl_system_items item

2259: WHERE line_id = p_order_line_id;
2260:
2261: CURSOR c_item_vendor(p_order_line_id IN NUMBER) IS
2262: SELECT line.attribute4
2263: FROM oe_order_lines_all line, mtl_system_items item
2264: WHERE line.line_id = p_order_line_id
2265: AND line.inventory_item_id = item.inventory_item_id;
2266:
2267: l_qualified_flag VARCHAR2(1) := 'Y';