DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on PO_LINES_ALL

Line 3841: FROM PO_LINES_ALL

3837: l_log_msg := l_log_msg || 'Source : BLANKET_PO_LINE_NUM ' || l_blanket_po_line_num;
3838:
3839: SELECT PO_LINE_ID, UDA_TEMPLATE_ID
3840: INTO l_po_line_id, l_from_template_id
3841: FROM PO_LINES_ALL
3842: WHERE PO_HEADER_ID = l_blanket_po_header_id
3843: AND LINE_NUM = l_blanket_po_line_num
3844: AND Nvl(DRAFT_ID, -1) = -1;
3845:

Line 4122: FROM po_lines_all

4118: END ;
4119:
4120: SELECT UNIT_MEAS_LOOKUP_CODE, MATCHING_BASIS
4121: INTO p_uom, l_matching_basis
4122: FROM po_lines_all
4123: WHERE po_line_id = l_po_line_id ;
4124:
4125: IF l_matching_basis = 'QUANTITY' THEN
4126: SELECT Round(Nvl(quantity_funded,0),15), Round(Nvl(quantity_funded,0) - Nvl(quantity_delivered,0),15)