APPS.OE_INVOICE_PUB dependencies on OE_LINE_TYPES_V

Line 1079: FROM oe_line_types_v lt

1075: -- Get cust_trx_type_id from line type
1076: --Bug2293944 Get information from the reference line or reference order.
1077: SELECT NVL(lt.cust_trx_type_id, 0)
1078: INTO l_inv_cust_trx_type_id
1079: FROM oe_line_types_v lt
1080: WHERE lt.line_type_id = (SELECT line_type_id
1081: FROM oe_order_lines_all /* MOAC SQL CHANGE */
1082: WHERE line_id = p_line_rec.reference_line_id);
1083: IF l_debug_level > 0 THEN

Line 1124: FROM oe_line_types_v lt

1120: l_inv_cust_trx_type_id := 0 ;
1121: END IF ;
1122: /*SELECT NVL(lt.cust_trx_type_id,0)
1123: INTO l_inv_cust_trx_type_id
1124: FROM oe_line_types_v lt
1125: WHERE lt.line_type_id = p_line_rec.line_type_id; */
1126: -- end bug 4200055
1127: IF l_debug_level > 0 THEN
1128: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM LINE TYPE : '||L_INV_CUST_TRX_TYPE_ID , 5 ) ;

Line 1624: FROM oe_line_types_v lt,

1620: (p_interface_line_rec.interface_line_attribute3 = '0')) THEN
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

Line 1650: FROM oe_line_types_v lt,

1646: ELSE -- Invoice numbering method is 'Automatic' OR 'delivery' with shipping information available
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

Line 1747: FROM oe_line_types_v lt

1743: l_cust_trx_type_id := 0 ;
1744: end if ;
1745: /*SELECT NVL(lt.cust_trx_type_id, 0)
1746: INTO l_cust_trx_type_id
1747: FROM oe_line_types_v lt
1748: WHERE lt.line_type_id = p_line_rec.line_type_id; */
1749: -- end bug 4200055
1750: IF l_debug_level > 0 THEN
1751: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM LINE TYPE : '||L_CUST_TRX_TYPE_ID , 5 ) ;

Line 1806: FROM oe_line_types_v lt

1802: l_inv_cust_trx_type_id := 0 ;
1803: end if ;
1804: /*SELECT NVL(lt.cust_trx_type_id, 0)
1805: INTO l_inv_cust_trx_type_id
1806: FROM oe_line_types_v lt
1807: WHERE lt.line_type_id = p_line_rec.line_type_id; */
1808: -- end bug 4200055
1809: IF l_debug_level > 0 THEN
1810: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM LINE TYPE : '||L_INV_CUST_TRX_TYPE_ID , 5 ) ;

Line 1882: FROM oe_line_types_v lt,

1878: SELECT NVL(lt.accounting_credit_method_code,ot.accounting_credit_method_code),--Bug 5699774
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