APPS.OE_INVOICE_PUB dependencies on OE_ORDER_TYPES_V

Line 1089: FROM oe_order_types_v ot,

1085: END IF;
1086: IF l_inv_cust_trx_type_id = 0 THEN
1087: SELECT NVL(ot.cust_trx_type_id,0)
1088: INTO l_inv_cust_trx_type_id
1089: FROM oe_order_types_v ot,
1090: oe_order_headers_all oh /* MOAC SQL CHANGE */
1091: WHERE ot.order_type_id = oh.order_type_id
1092: AND oh.header_id = (SELECT header_id
1093: FROM oe_order_lines_all /* MOAC SQL CHANGE */

Line 1134: FROM oe_order_types_v ot,

1130: IF l_inv_cust_trx_type_id = 0 THEN
1131: -- Get cust_trx_type_id from order type
1132: SELECT NVL(ot.cust_trx_type_id, 0)
1133: INTO l_inv_cust_trx_type_id
1134: FROM oe_order_types_v ot,
1135: oe_order_headers_all oh /* MOAC SQL CHANGE */
1136: WHERE ot.order_type_id = oh.order_type_id
1137: AND oh.header_id = p_line_rec.header_id;
1138: END IF;

Line 1625: oe_order_types_v ot,

1621: SELECT NVL(lt.non_delivery_invoice_source_id,
1622: ot.non_delivery_invoice_source_id)
1623: INTO l_invoice_source_id
1624: FROM oe_line_types_v lt,
1625: oe_order_types_v ot,
1626: oe_order_headers_all oh /* MOAC SQL CHANGE */
1627: WHERE lt.line_type_id = p_line_rec.line_type_id
1628: AND ot.order_type_id = oh.order_type_id
1629: AND oh.header_id = p_line_rec.header_id;

Line 1651: oe_order_types_v ot,

1647: SELECT NVL(lt.invoice_source_id,
1648: ot.invoice_source_id)
1649: INTO l_invoice_source_id
1650: FROM oe_line_types_v lt,
1651: oe_order_types_v ot,
1652: oe_order_headers_all oh /* MOAC SQL CHANGE */
1653: WHERE lt.line_type_id = p_line_rec.line_type_id
1654: AND ot.order_type_id = oh.order_type_id
1655: AND oh.header_id = p_line_rec.header_id;

Line 1756: FROM oe_order_types_v ot,

1752: END IF;
1753: IF l_cust_trx_type_id = 0 THEN
1754: SELECT NVL(ot.cust_trx_type_id, 0)
1755: INTO l_cust_trx_type_id
1756: FROM oe_order_types_v ot,
1757: oe_order_headers_all oh /* MOAC SQL CHANGE */
1758: WHERE ot.order_type_id = oh.order_type_id
1759: AND oh.header_id = p_line_rec.header_id;
1760: IF l_debug_level > 0 THEN

Line 1816: FROM oe_order_types_v ot,

1812: --Bug2293944 Removed the decode statement.
1813: IF l_inv_cust_trx_type_id = 0 THEN
1814: SELECT NVL(ot.cust_trx_type_id,0)
1815: INTO l_inv_cust_trx_type_id
1816: FROM oe_order_types_v ot,
1817: oe_order_headers_all oh /* MOAC SQL CHANGE */
1818: WHERE ot.order_type_id = oh.order_type_id
1819: AND oh.header_id = p_line_rec.header_id;
1820: IF l_debug_level > 0 THEN

Line 1883: oe_order_types_v ot,

1879: NVL(lt.invoicing_credit_method_code,ot.invoicing_credit_method_code) --Bug 5699774
1880: INTO l_accting_credit_method_code,
1881: l_invcing_credit_method_code
1882: FROM oe_line_types_v lt,
1883: oe_order_types_v ot,
1884: oe_order_headers_all oh /* MOAC SQL CHANGE */
1885: WHERE lt.line_type_id = p_line_rec.line_type_id
1886: AND ot.order_type_id = oh.order_type_id
1887: AND oh.header_id = p_line_rec.header_id;