APPS.OE_INVOICE_PUB dependencies on DUAL

Line 414: FROM Dual;

410: Oe_Header_Util.Query_Row(l_line_rec.header_id, l_header_rec);
411:
412: SELECT oe_xml_message_seq_s.NEXTVAL
413: INTO l_item_key_sso
414: FROM Dual;
415:
416: IF l_debug_level > 0 THEN
417: oe_debug_pub.add(' l_item_key_sso: ' || l_item_key_sso);
418: END IF;

Line 487: FROM DUAL;

483: IF Oe_Genesis_Util.Source_AIA_Enabled(l_header_rec.order_source_id) THEN
484:
485: SELECT oe_xml_message_seq_s.NEXTVAL
486: INTO l_item_key_sso
487: FROM DUAL;
488:
489: IF l_debug_level > 0 THEN
490: oe_debug_pub.add(' l_item_key_sso: ' || l_item_key_sso);
491: END IF;

Line 1766: FROM DUAL;

1762: END IF;
1763: IF l_cust_trx_type_id = 0 THEN
1764: SELECT NVL(oe_sys_parameters.value('OE_INVOICE_TRANSACTION_TYPE_ID',p_line_rec.org_id), 0) --moac
1765: INTO l_cust_trx_type_id
1766: FROM DUAL;
1767: IF l_debug_level > 0 THEN
1768: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM PROFILE : '||L_CUST_TRX_TYPE_ID , 5 ) ;
1769: END IF;
1770: END IF;

Line 1785: FROM DUAL;

1781: Return_Credit_Info(p_line_rec, l_cust_trx_type_id, l_creation_sign);
1782: IF l_cust_trx_type_id = 0 THEN -- no cust_trx_type_id at line/order type
1783: SELECT OE_SYS_PARAMETERS.Value('OE_CREDIT_TRANSACTION_TYPE_ID',p_line_rec.org_id) --moac
1784: INTO l_cust_trx_type_id
1785: FROM DUAL;
1786: IF l_debug_level > 0 THEN
1787: oe_debug_pub.add( ' CUSTOMER TRANSACTION TYPE ID FROM PROFILE ' , 5 ) ;
1788: END IF;
1789: END IF;

Line 1846: FROM DUAL;

1842: END IF;
1843: IF l_inv_cust_trx_type_id = 0 OR l_cust_trx_type_id = 0 THEN
1844: SELECT NVL(oe_sys_parameters.value('OE_CREDIT_TRANSACTION_TYPE_ID',p_line_rec.org_id), 0) --moac
1845: INTO l_cust_trx_type_id
1846: FROM DUAL;
1847: IF l_debug_level > 0 THEN
1848: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM PROFILE' , 5 ) ;
1849: END IF;
1850: END IF;

Line 2137: From dual;

2133: l_ratio := nvl(p_line_rec.ordered_quantity,0) / l_child_total_ordered_qty;
2134: -- ordered_quantity must be according to ratio
2135: Select Floor(nvl(l_child_total_fulfilled_qty, 0) * nvl(p_line_rec.ordered_quantity,0) / l_child_total_ordered_qty)
2136: Into max_to_invoice
2137: From dual;
2138: IF max_to_invoice < qty_to_invoice THEN
2139: IF l_debug_level > 0 THEN
2140: oe_debug_pub.add( 'RFR: MAX_TO_INVOICE < QTY_TO_INVOICE' , 5 ) ;
2141: END IF;

Line 2188: From dual;

2184: l_ratio := l_total_ordered_qty / l_sibling_total_ordered_qty;
2185: -- ordered_quantity must be according to ratio
2186: Select Floor(nvl(l_sibling_total_fulfilled_qty, 0) * l_total_ordered_qty / l_sibling_total_ordered_qty)
2187: Into max_to_invoice
2188: From dual;
2189: IF max_to_invoice < qty_to_invoice THEN
2190: qty_to_invoice := max_to_invoice;
2191: END IF;
2192: END IF; -- new inventory_item_id

Line 2445: From dual;

2441: END IF;
2442: -- ordered_quantity must be according to ratio
2443: Select Floor(nvl(l_child_total_fulfilled_qty, 0) * nvl(p_line_rec.ordered_quantity, 0) / l_child_total_ordered_qty)
2444: Into max_to_invoice
2445: From dual;
2446: IF l_debug_level > 0 THEN
2447: oe_debug_pub.add( 'RFR:MAX_TO_INVOICE: '||MAX_TO_INVOICE , 5 ) ;
2448: END IF;
2449: IF max_to_invoice < qty_to_invoice THEN