APPS.CSI_INTERFACE_PKG dependencies on OE_ORDER_LINES_ALL

Line 123: FROM oe_order_lines_all

119: org_id
120: INTO l_inventory_item_id ,
121: l_next_parent_line_id,
122: l_org_id
123: FROM oe_order_lines_all
124: WHERE line_id = l_parent_line_id;
125:
126: l_organization_id := oe_sys_parameters.value(
127: param_name => 'MASTER_ORGANIZATION_ID',

Line 252: FROM oe_order_lines_all

248: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
249:
250: CURSOR op_cur is
251: SELECT line_id
252: FROM oe_order_lines_all
253: WHERE link_to_line_id = p_parent_line_id
254: ORDER BY line_number, shipment_number;
255:
256: BEGIN

Line 1669: IF px_txn_line_rec.source_transaction_table = 'OE_ORDER_LINES_ALL' THEN

1665: px_txn_party_tbl := l_pty_tbl;
1666: px_txn_party_acct_tbl := l_pa_tbl;
1667: px_txn_org_assgn_tbl := l_oa_tbl;
1668:
1669: IF px_txn_line_rec.source_transaction_table = 'OE_ORDER_LINES_ALL' THEN
1670:
1671: get_pricing_attributes(
1672: p_line_id => px_txn_line_rec.source_transaction_id,
1673: x_pricing_attribs_tbl => x_pricing_attribs_tbl,

Line 1824: FROM oe_order_lines_all

1820: CURSOR keys_cur IS
1821: SELECT config_header_id config_session_hdr_id,
1822: config_rev_nbr config_session_rev_num,
1823: configuration_id config_session_item_id
1824: FROM oe_order_lines_all
1825: WHERE header_id = p_header_id;
1826:
1827: l_ind binary_integer := 0;
1828:

Line 2619: l_line_rec oe_order_lines_all%rowtype;

2615: x_source_line_rec OUT NOCOPY source_line_rec,
2616: x_return_status OUT NOCOPY varchar2)
2617: IS
2618:
2619: l_line_rec oe_order_lines_all%rowtype;
2620: l_hdr_rec oe_order_headers_all%rowtype;
2621:
2622: -- For partner prdering
2623: l_partner_rec oe_install_base_util.partner_order_rec;

Line 2637: FROM oe_order_lines_all

2633: api_log('get_order_line_source_info');
2634:
2635: BEGIN
2636: SELECT * INTO l_line_rec
2637: FROM oe_order_lines_all
2638: WHERE line_id = p_order_line_id;
2639:
2640: SELECT * INTO l_hdr_rec
2641: FROM oe_order_headers_all