DBA Data[Home] [Help]

APPS.OKC_REP_UDA_FUNCTIONS dependencies on PO_LINES_DRAFT_ALL

Line 123: FROM (SELECT po_line_id FROM po_lines_draft_all WHERE draft_id = p_source_doc_id

119:
120: ELSIF p_source_doc_type = 'PO_STANDARD_MOD' OR p_source_doc_type = 'PA_BLANKET_MOD' THEN
121: --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD (PA_CONTRACT_MOD doesn't have lines)
122: SELECT po_line_id INTO l_po_line_id
123: FROM (SELECT po_line_id FROM po_lines_draft_all WHERE draft_id = p_source_doc_id
124: ORDER BY getPoLineAmount(po_header_id, po_line_id, draft_id) DESC, item_description ASC)
125: WHERE rownum = 1;
126: END IF;
127: EXCEPTION