APPS.OE_INVOICE_PUB dependencies on OE_CHARGE_LINES_V

Line 5391: FROM oe_charge_lines_v

5387: ,substrb(ATTRIBUTE12, 1, 150)
5388: ,substrb(ATTRIBUTE13, 1, 150)
5389: ,substrb(ATTRIBUTE14, 1, 150)
5390: ,substrb(ATTRIBUTE15, 1, 150)
5391: FROM oe_charge_lines_v
5392: WHERE header_id = p_header_id
5393: AND line_id = p_line_id
5394: AND nvl(invoiced_flag, 'N') = 'N';
5395:

Line 5418: FROM oe_charge_lines_v

5414: ,substrb(ATTRIBUTE12, 1, 150)
5415: ,substrb(ATTRIBUTE13, 1, 150)
5416: ,substrb(ATTRIBUTE14, 1, 150)
5417: ,substrb(ATTRIBUTE15, 1, 150)
5418: FROM oe_charge_lines_v
5419: WHERE header_id = p_line_rec.header_id
5420: AND line_id IS NULL
5421: AND nvl(invoiced_flag, 'N') = 'N'
5422: for update nowait; -- Bug #3686558

Line 5447: FROM oe_charge_lines_v

5443: ,substrb(ATTRIBUTE12, 1, 150)
5444: ,substrb(ATTRIBUTE13, 1, 150)
5445: ,substrb(ATTRIBUTE14, 1, 150)
5446: ,substrb(ATTRIBUTE15, 1, 150)
5447: FROM oe_charge_lines_v
5448: WHERE header_id = p_header_id
5449: AND line_id IS NULL
5450: AND nvl(invoiced_flag, 'N') = 'Y'
5451: AND invoiced_amount IS NOT NULL

Line 6553: FROM oe_charge_lines_v

6549: l_fulfilled_qty := NVL(p_line_rec.fulfilled_quantity, NVL(p_line_rec.shipped_quantity, NVL(p_line_rec.ordered_quantity, 0)));
6550: l_partial_line_tax_amount := nvl(p_line_rec.tax_value * (p_x_interface_line_rec.QUANTITY/l_fulfilled_qty), 0);
6551: SELECT nvl(sum(charge_amount), 0)
6552: INTO l_partial_line_freight_amount
6553: FROM oe_charge_lines_v
6554: WHERE header_id = p_line_rec.header_id
6555: AND line_id = p_line_rec.line_id
6556: AND nvl(invoiced_flag, 'N') = 'N';
6557: END IF;