APPS.PO_VAL_LINES dependencies on PO_LINES_MERGE_V

Line 1472: FROM PO_LINES_MERGE_V

1468: IF (p_draft_id_tbl(i) IS NOT NULL AND p_draft_id_tbl(i) <> -1) THEN
1469:
1470: SELECT Count(po_line_id)
1471: INTO line_count
1472: FROM PO_LINES_MERGE_V
1473: WHERE (draft_id= -1
1474: OR draft_id IS NULL)
1475: AND po_line_id = p_line_id_tbl(i);
1476:

Line 3627: FROM PO_LINES_MERGE_V

3623: IF (p_draft_id_tbl(i) IS NOT NULL AND p_draft_id_tbl(i) <> -1 ) THEN
3624: BEGIN
3625: SELECT CLM_OPTION_FROM_DATE
3626: INTO document_option_date
3627: FROM PO_LINES_MERGE_V
3628: WHERE (draft_id = -1
3629: OR draft_id IS NULL)
3630: AND po_line_id = p_line_id_tbl(i);
3631: EXCEPTION

Line 3987: FROM PO_LINES_MERGE_V LINE

3983: , LINE.po_header_id
3984: , LINE.po_line_id
3985: , LINE.group_line_id
3986: , LINE.line_num_display
3987: FROM PO_LINES_MERGE_V LINE
3988: WHERE LINE.po_header_id =l_parent_id_tbl(i)
3989: AND LINE.draft_id <> p_draft_id_tbl(i)
3990: AND LINE.draft_id NOT IN (SELECT * FROM TABLE(l_par_draft_id_tbl))
3991: AND Nvl(LINE.mod_line_id, -999) <> p_line_id_tbl(i); --

Line 5157: FROM PO_LINES_MERGE_V POL

5153: , c_CLM_EXHIBIT_NAME
5154: , TO_CHAR(p_exhibit_name_tbl(i))
5155: , PO_MESSAGE_S.PO_INVALID_EXHIBIT_NAME
5156:
5157: FROM PO_LINES_MERGE_V POL
5158: WHERE NOT EXISTS (SELECT 1
5159: FROM FND_LOOKUP_VALUES LK
5160: WHERE LOOKUP_TYPE = 'PO_CLM_EXHIBIT_NUMBER'
5161: AND ENABLED_FLAG = 'Y'