APPS.OE_INVOICE_PUB dependencies on OE_ORDER_TYPES_V

Line 874: FROM oe_order_types_v ot,

870: END IF;
871: IF l_inv_cust_trx_type_id = 0 THEN
872: SELECT NVL(ot.cust_trx_type_id,0)
873: INTO l_inv_cust_trx_type_id
874: FROM oe_order_types_v ot,
875: oe_order_headers_all oh /* MOAC SQL CHANGE */
876: WHERE ot.order_type_id = oh.order_type_id
877: AND oh.header_id = (SELECT header_id
878: FROM oe_order_lines_all /* MOAC SQL CHANGE */

Line 919: FROM oe_order_types_v ot,

915: IF l_inv_cust_trx_type_id = 0 THEN
916: -- Get cust_trx_type_id from order type
917: SELECT NVL(ot.cust_trx_type_id, 0)
918: INTO l_inv_cust_trx_type_id
919: FROM oe_order_types_v ot,
920: oe_order_headers_all oh /* MOAC SQL CHANGE */
921: WHERE ot.order_type_id = oh.order_type_id
922: AND oh.header_id = p_line_rec.header_id;
923: END IF;

Line 1408: oe_order_types_v ot,

1404: SELECT NVL(lt.non_delivery_invoice_source_id,
1405: ot.non_delivery_invoice_source_id)
1406: INTO l_invoice_source_id
1407: FROM oe_line_types_v lt,
1408: oe_order_types_v ot,
1409: oe_order_headers_all oh /* MOAC SQL CHANGE */
1410: WHERE lt.line_type_id = p_line_rec.line_type_id
1411: AND ot.order_type_id = oh.order_type_id
1412: AND oh.header_id = p_line_rec.header_id;

Line 1434: oe_order_types_v ot,

1430: SELECT NVL(lt.invoice_source_id,
1431: ot.invoice_source_id)
1432: INTO l_invoice_source_id
1433: FROM oe_line_types_v lt,
1434: oe_order_types_v ot,
1435: oe_order_headers_all oh /* MOAC SQL CHANGE */
1436: WHERE lt.line_type_id = p_line_rec.line_type_id
1437: AND ot.order_type_id = oh.order_type_id
1438: AND oh.header_id = p_line_rec.header_id;

Line 1539: FROM oe_order_types_v ot,

1535: END IF;
1536: IF l_cust_trx_type_id = 0 THEN
1537: SELECT NVL(ot.cust_trx_type_id, 0)
1538: INTO l_cust_trx_type_id
1539: FROM oe_order_types_v ot,
1540: oe_order_headers_all oh /* MOAC SQL CHANGE */
1541: WHERE ot.order_type_id = oh.order_type_id
1542: AND oh.header_id = p_line_rec.header_id;
1543: IF l_debug_level > 0 THEN

Line 1599: FROM oe_order_types_v ot,

1595: --Bug2293944 Removed the decode statement.
1596: IF l_inv_cust_trx_type_id = 0 THEN
1597: SELECT NVL(ot.cust_trx_type_id,0)
1598: INTO l_inv_cust_trx_type_id
1599: FROM oe_order_types_v ot,
1600: oe_order_headers_all oh /* MOAC SQL CHANGE */
1601: WHERE ot.order_type_id = oh.order_type_id
1602: AND oh.header_id = p_line_rec.header_id;
1603: IF l_debug_level > 0 THEN

Line 1666: oe_order_types_v ot,

1662: NVL(lt.invoicing_credit_method_code,ot.invoicing_credit_method_code) --Bug 5699774
1663: INTO l_accting_credit_method_code,
1664: l_invcing_credit_method_code
1665: FROM oe_line_types_v lt,
1666: oe_order_types_v ot,
1667: oe_order_headers_all oh /* MOAC SQL CHANGE */
1668: WHERE lt.line_type_id = p_line_rec.line_type_id
1669: AND ot.order_type_id = oh.order_type_id
1670: AND oh.header_id = p_line_rec.header_id;