DBA Data[Home] [Help]

APPS.OKL_ARINTF_PVT dependencies on STANDARD

Line 84: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id

80:
81: -- nikshah -- Bug # 5484903 Fixed,
82: -- Changed CURSOR line_bill_to_csr SQL definition
83: CURSOR line_bill_to_csr(p_khr_id NUMBER, p_kle_id NUMBER) IS
84: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
85: FROM okc_k_headers_b khr
86: , okx_cust_site_uses_v cs
87: , okc_k_lines_b cle
88: , hz_customer_profiles cp

Line 96: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id

92: AND cle.id = p_kle_id
93: AND cle.BILL_TO_SITE_USE_ID = cs.id1
94: AND khr.bill_to_site_use_id = cp.site_use_id(+)
95: UNION
96: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
97: FROM okc_k_headers_b khr
98: , okc_k_lines_b cle
99: , okc_k_items item
100: , okc_k_lines_b linked_asset

Line 3604: inv_lines_tbl(hdr_cnt).UNIT_STANDARD_PRICE := NULL;

3600: END IF;
3601:
3602: inv_lines_tbl(hdr_cnt).TERM_ID := l_xfer_tbl(k).TERM_ID;
3603: inv_lines_tbl(hdr_cnt).UNIT_SELLING_PRICE := NULL;
3604: inv_lines_tbl(hdr_cnt).UNIT_STANDARD_PRICE := NULL;
3605: inv_lines_tbl(hdr_cnt).UOM_CODE := l_xfer_tbl(k).uom_code;
3606: --Bug# 13340410: Moved this code above
3607: --inv_lines_tbl(hdr_cnt).ORG_ID := l_xfer_tbl(k).ORG_ID;
3608: inv_lines_tbl(hdr_cnt).LEGAL_ENTITY_ID := l_xfer_tbl(k).LEGAL_ENTITY_ID; -- for LE Uptake project 08-11-2006

Line 3633: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','inv_lines_tbl('||hdr_cnt||').unit_standard_price:' || inv_lines_tbl(hdr_cnt).unit_standard_price);

3629: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','inv_lines_tbl('||hdr_cnt||').tax_exempt_number:' || inv_lines_tbl(hdr_cnt).tax_exempt_number);
3630: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','inv_lines_tbl('||hdr_cnt||').tax_exempt_reason_code:' || inv_lines_tbl(hdr_cnt).tax_exempt_reason_code);
3631: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','inv_lines_tbl('||hdr_cnt||').term_id:' || inv_lines_tbl(hdr_cnt).term_id);
3632: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','inv_lines_tbl('||hdr_cnt||').unit_selling_price:' || inv_lines_tbl(hdr_cnt).unit_selling_price);
3633: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','inv_lines_tbl('||hdr_cnt||').unit_standard_price:' || inv_lines_tbl(hdr_cnt).unit_standard_price);
3634: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','inv_lines_tbl('||hdr_cnt||').uom_code:' || inv_lines_tbl(hdr_cnt).uom_code);
3635: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Preparing Ra_interface_lines_all record.');
3636: END IF;
3637: -- Start Sales Tax Code