eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on STANDARD

Line 70: , cp.standard_terms payment_term_id

66: /*
67: --added for rules migration
68: CURSOR cust_acct_csr (p_khr_id NUMBER) IS
69: SELECT cs.cust_acct_site_id
70: , cp.standard_terms payment_term_id
71: FROM okc_k_headers_v khr
72: , okx_cust_site_uses_v cs
73: , hz_customer_profiles cp
74: WHERE khr.id = p_khr_id

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

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

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

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

Line 1479: -- l_trx_lines_tbl(1).UNIT_STANDARD_PRICE := r_xlsv_rec.AMOUNT;

1475: l_trx_lines_tbl(1).QUANTITY_INVOICED := lxfer_rec.QUANTITY;
1476: end if;
1477: -- l_trx_lines_tbl(1).QUANTITY_INVOICED := 1;
1478: --end: migrated from oklarintf_pvt
1479: -- l_trx_lines_tbl(1).UNIT_STANDARD_PRICE := r_xlsv_rec.AMOUNT;
1480: -- l_trx_lines_tbl(1).UNIT_SELLING_PRICE := r_xlsv_rec.AMOUNT;
1481: l_trx_lines_tbl(1).UNIT_STANDARD_PRICE := lxfer_rec.AMOUNT;
1482: l_trx_lines_tbl(1).UNIT_SELLING_PRICE := lxfer_rec.AMOUNT;
1483: --end: 02-APR-07 cklee R12 Billing enhancement project |

Line 1481: l_trx_lines_tbl(1).UNIT_STANDARD_PRICE := lxfer_rec.AMOUNT;

1477: -- l_trx_lines_tbl(1).QUANTITY_INVOICED := 1;
1478: --end: migrated from oklarintf_pvt
1479: -- l_trx_lines_tbl(1).UNIT_STANDARD_PRICE := r_xlsv_rec.AMOUNT;
1480: -- l_trx_lines_tbl(1).UNIT_SELLING_PRICE := r_xlsv_rec.AMOUNT;
1481: l_trx_lines_tbl(1).UNIT_STANDARD_PRICE := lxfer_rec.AMOUNT;
1482: l_trx_lines_tbl(1).UNIT_SELLING_PRICE := lxfer_rec.AMOUNT;
1483: --end: 02-APR-07 cklee R12 Billing enhancement project |
1484: l_trx_lines_tbl(1).SALES_ORDER := NULL;
1485: l_trx_lines_tbl(1).SALES_ORDER_LINE := NULL;

Line 2909: fnd_file.put_line(fnd_file.output,'unit standard

2905: fnd_file.put_line(fnd_file.output,'Inventory Item
2906: Id:'||l_trx_lines_tbl(i).inventory_item_id);
2907: fnd_file.put_line(fnd_file.output,'Quantity Ordered
2908: :'||l_trx_lines_tbl(i).quantity_ordered);
2909: fnd_file.put_line(fnd_file.output,'unit standard
2910: price:'||l_trx_lines_tbl(i).unit_standard_price);
2911: fnd_file.put_line(fnd_file.output,'unit selling price
2912: '||l_trx_lines_tbl(i).unit_selling_price);
2913: fnd_file.put_line(fnd_file.output,'line type:'||l_trx_lines_tbl(i).line_type);

Line 2910: price:'||l_trx_lines_tbl(i).unit_standard_price);

2906: Id:'||l_trx_lines_tbl(i).inventory_item_id);
2907: fnd_file.put_line(fnd_file.output,'Quantity Ordered
2908: :'||l_trx_lines_tbl(i).quantity_ordered);
2909: fnd_file.put_line(fnd_file.output,'unit standard
2910: price:'||l_trx_lines_tbl(i).unit_standard_price);
2911: fnd_file.put_line(fnd_file.output,'unit selling price
2912: '||l_trx_lines_tbl(i).unit_selling_price);
2913: fnd_file.put_line(fnd_file.output,'line type:'||l_trx_lines_tbl(i).line_type);
2914: fnd_file.put_line(fnd_file.output,'Interface Line