DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on OE_CHARGE_LINES_V

Line 5147: FROM oe_charge_lines_v

5143: ,substrb(ATTRIBUTE12, 1, 150)
5144: ,substrb(ATTRIBUTE13, 1, 150)
5145: ,substrb(ATTRIBUTE14, 1, 150)
5146: ,substrb(ATTRIBUTE15, 1, 150)
5147: FROM oe_charge_lines_v
5148: WHERE header_id = p_header_id
5149: AND line_id = p_line_id
5150: AND nvl(invoiced_flag, 'N') = 'N';
5151:

Line 5174: FROM oe_charge_lines_v

5170: ,substrb(ATTRIBUTE12, 1, 150)
5171: ,substrb(ATTRIBUTE13, 1, 150)
5172: ,substrb(ATTRIBUTE14, 1, 150)
5173: ,substrb(ATTRIBUTE15, 1, 150)
5174: FROM oe_charge_lines_v
5175: WHERE header_id = p_line_rec.header_id
5176: AND line_id IS NULL
5177: AND nvl(invoiced_flag, 'N') = 'N'
5178: for update nowait; -- Bug #3686558

Line 5203: FROM oe_charge_lines_v

5199: ,substrb(ATTRIBUTE12, 1, 150)
5200: ,substrb(ATTRIBUTE13, 1, 150)
5201: ,substrb(ATTRIBUTE14, 1, 150)
5202: ,substrb(ATTRIBUTE15, 1, 150)
5203: FROM oe_charge_lines_v
5204: WHERE header_id = p_header_id
5205: AND line_id IS NULL
5206: AND nvl(invoiced_flag, 'N') = 'Y'
5207: AND invoiced_amount IS NOT NULL

Line 6290: FROM oe_charge_lines_v

6286: l_fulfilled_qty := NVL(p_line_rec.fulfilled_quantity, NVL(p_line_rec.shipped_quantity, NVL(p_line_rec.ordered_quantity, 0)));
6287: l_partial_line_tax_amount := nvl(p_line_rec.tax_value * (p_x_interface_line_rec.QUANTITY/l_fulfilled_qty), 0);
6288: SELECT nvl(sum(charge_amount), 0)
6289: INTO l_partial_line_freight_amount
6290: FROM oe_charge_lines_v
6291: WHERE header_id = p_line_rec.header_id
6292: AND line_id = p_line_rec.line_id
6293: AND nvl(invoiced_flag, 'N') = 'N';
6294: END IF;