APPS.OKL_CONS_BILL dependencies on OKL_XTL_SELL_INVS_B

Line 178: UPDATE Okl_Xtl_Sell_Invs_b

174: last_updated_by = Fnd_Global.USER_ID,
175: last_update_login = Fnd_Global.LOGIN_ID
176: WHERE id = l_update_tbl(m).xsi_id;
177:
178: UPDATE Okl_Xtl_Sell_Invs_b
179: SET LSM_ID = l_update_tbl(m).LSM_ID,
180: -- XTRX_CONS_LINE_NUMBER = l_update_tbl(m).line_number,
181: XTRX_CONS_STREAM_ID = l_update_tbl(m).lsm_id,
182: last_update_date = sysdate,

Line 1728: okl_xtl_sell_invs_b xls,

1724: xls.amount cm2_amount,
1725: xls.sel_id sel_id,
1726: xsi.legal_entity_id legal_entity_id --FOR le uptake project 8 -11 -2006
1727: FROM okl_ext_sell_invs_v xsi,
1728: okl_xtl_sell_invs_b xls,
1729: okl_txl_ar_inv_lns_b til,
1730: okl_trx_ar_invoices_b tai,
1731: okc_k_headers_all_b CHR,
1732: okl_parallel_processes pws

Line 1769: okl_xtl_sell_invs_b xls,

1765: xls.sel_id sel_id,
1766: xsi.legal_entity_id legal_entity_id --FOR le uptake project 8 -11 -2006
1767: FROM okl_ext_sell_invs_v xsi,
1768: okl_ext_sell_invs_v xsir,
1769: okl_xtl_sell_invs_b xls,
1770: okl_xtl_sell_invs_b xlsr,
1771: okl_txl_ar_inv_lns_b til,
1772: okl_trx_ar_invoices_b tai,
1773: okc_k_headers_all_b CHR,

Line 1770: okl_xtl_sell_invs_b xlsr,

1766: xsi.legal_entity_id legal_entity_id --FOR le uptake project 8 -11 -2006
1767: FROM okl_ext_sell_invs_v xsi,
1768: okl_ext_sell_invs_v xsir,
1769: okl_xtl_sell_invs_b xls,
1770: okl_xtl_sell_invs_b xlsr,
1771: okl_txl_ar_inv_lns_b til,
1772: okl_trx_ar_invoices_b tai,
1773: okc_k_headers_all_b CHR,
1774: okl_parallel_processes pws

Line 3086: UPDATE Okl_Xtl_Sell_Invs_b

3082: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRKONB.pls call Okl_Xtl_Sell_Invs_Pub.UPDATE_XTL_SELL_INVS ');
3083: END;
3084: END IF;
3085:
3086: UPDATE Okl_Xtl_Sell_Invs_b
3087: SET LSM_ID = l_xlsv_rec.LSM_ID,
3088: XTRX_CONS_LINE_NUMBER = l_xlsv_rec.XTRX_CONS_LINE_NUMBER,
3089: XTRX_CONS_STREAM_ID = l_xlsv_rec.XTRX_CONS_STREAM_ID
3090: WHERE id = l_xlsv_rec.id;