APPS.OE_INVOICE_PUB dependencies on DUAL

Line 1549: FROM DUAL;

1545: END IF;
1546: IF l_cust_trx_type_id = 0 THEN
1547: SELECT NVL(oe_sys_parameters.value('OE_INVOICE_TRANSACTION_TYPE_ID',p_line_rec.org_id), 0) --moac
1548: INTO l_cust_trx_type_id
1549: FROM DUAL;
1550: IF l_debug_level > 0 THEN
1551: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM PROFILE : '||L_CUST_TRX_TYPE_ID , 5 ) ;
1552: END IF;
1553: END IF;

Line 1568: FROM DUAL;

1564: Return_Credit_Info(p_line_rec, l_cust_trx_type_id, l_creation_sign);
1565: IF l_cust_trx_type_id = 0 THEN -- no cust_trx_type_id at line/order type
1566: SELECT OE_SYS_PARAMETERS.Value('OE_CREDIT_TRANSACTION_TYPE_ID',p_line_rec.org_id) --moac
1567: INTO l_cust_trx_type_id
1568: FROM DUAL;
1569: IF l_debug_level > 0 THEN
1570: oe_debug_pub.add( ' CUSTOMER TRANSACTION TYPE ID FROM PROFILE ' , 5 ) ;
1571: END IF;
1572: END IF;

Line 1629: FROM DUAL;

1625: END IF;
1626: IF l_inv_cust_trx_type_id = 0 OR l_cust_trx_type_id = 0 THEN
1627: SELECT NVL(oe_sys_parameters.value('OE_CREDIT_TRANSACTION_TYPE_ID',p_line_rec.org_id), 0) --moac
1628: INTO l_cust_trx_type_id
1629: FROM DUAL;
1630: IF l_debug_level > 0 THEN
1631: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM PROFILE' , 5 ) ;
1632: END IF;
1633: END IF;

Line 1920: From dual;

1916: l_ratio := nvl(p_line_rec.ordered_quantity,0) / l_child_total_ordered_qty;
1917: -- ordered_quantity must be according to ratio
1918: Select Floor(nvl(l_child_total_fulfilled_qty, 0) * nvl(p_line_rec.ordered_quantity,0) / l_child_total_ordered_qty)
1919: Into max_to_invoice
1920: From dual;
1921: IF max_to_invoice < qty_to_invoice THEN
1922: IF l_debug_level > 0 THEN
1923: oe_debug_pub.add( 'RFR: MAX_TO_INVOICE < QTY_TO_INVOICE' , 5 ) ;
1924: END IF;

Line 1971: From dual;

1967: l_ratio := l_total_ordered_qty / l_sibling_total_ordered_qty;
1968: -- ordered_quantity must be according to ratio
1969: Select Floor(nvl(l_sibling_total_fulfilled_qty, 0) * l_total_ordered_qty / l_sibling_total_ordered_qty)
1970: Into max_to_invoice
1971: From dual;
1972: IF max_to_invoice < qty_to_invoice THEN
1973: qty_to_invoice := max_to_invoice;
1974: END IF;
1975: END IF; -- new inventory_item_id

Line 2228: From dual;

2224: END IF;
2225: -- ordered_quantity must be according to ratio
2226: Select Floor(nvl(l_child_total_fulfilled_qty, 0) * nvl(p_line_rec.ordered_quantity, 0) / l_child_total_ordered_qty)
2227: Into max_to_invoice
2228: From dual;
2229: IF l_debug_level > 0 THEN
2230: oe_debug_pub.add( 'RFR:MAX_TO_INVOICE: '||MAX_TO_INVOICE , 5 ) ;
2231: END IF;
2232: IF max_to_invoice < qty_to_invoice THEN