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 1698: IF px_txn_line_rec.source_transaction_table = 'OE_ORDER_LINES_ALL' THEN

1694: px_txn_party_tbl := l_pty_tbl;
1695: px_txn_party_acct_tbl := l_pa_tbl;
1696: px_txn_org_assgn_tbl := l_oa_tbl;
1697:
1698: IF px_txn_line_rec.source_transaction_table = 'OE_ORDER_LINES_ALL' THEN
1699:
1700: get_pricing_attributes(
1701: p_line_id => px_txn_line_rec.source_transaction_id,
1702: x_pricing_attribs_tbl => x_pricing_attribs_tbl,

Line 1853: FROM oe_order_lines_all

1849: CURSOR keys_cur IS
1850: SELECT config_header_id config_session_hdr_id,
1851: config_rev_nbr config_session_rev_num,
1852: configuration_id config_session_item_id
1853: FROM oe_order_lines_all
1854: WHERE header_id = p_header_id;
1855:
1856: l_ind binary_integer := 0;
1857:

Line 2653: l_line_rec oe_order_lines_all%rowtype;

2649: x_source_line_rec OUT NOCOPY source_line_rec,
2650: x_return_status OUT NOCOPY varchar2)
2651: IS
2652:
2653: l_line_rec oe_order_lines_all%rowtype;
2654: l_hdr_rec oe_order_headers_all%rowtype;
2655:
2656: -- For partner prdering
2657: l_partner_rec oe_install_base_util.partner_order_rec;

Line 2671: FROM oe_order_lines_all

2667: api_log('get_order_line_source_info');
2668:
2669: BEGIN
2670: SELECT * INTO l_line_rec
2671: FROM oe_order_lines_all
2672: WHERE line_id = p_order_line_id;
2673:
2674: SELECT * INTO l_hdr_rec
2675: FROM oe_order_headers_all