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 2421: inv_lines_tbl(hdr_cnt).UNIT_STANDARD_PRICE := NULL;

2417: END IF;
2418:
2419: inv_lines_tbl(hdr_cnt).TERM_ID := l_xfer_tbl(k).TERM_ID;
2420: inv_lines_tbl(hdr_cnt).UNIT_SELLING_PRICE := NULL;
2421: inv_lines_tbl(hdr_cnt).UNIT_STANDARD_PRICE := NULL;
2422: inv_lines_tbl(hdr_cnt).UOM_CODE := l_xfer_tbl(k).uom_code;
2423: inv_lines_tbl(hdr_cnt).ORG_ID := l_xfer_tbl(k).ORG_ID;
2424: inv_lines_tbl(hdr_cnt).LEGAL_ENTITY_ID := l_xfer_tbl(k).LEGAL_ENTITY_ID; -- for LE Uptake project 08-11-2006
2425:

Line 2449: 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);

2445: 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);
2446: 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);
2447: 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);
2448: 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);
2449: 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);
2450: 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);
2451: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Preparing Ra_interface_lines_all record.');
2452: END IF;
2453: -- Start Sales Tax Code