APPS.PO_DOC_STYLE_PVT dependencies on PO_HEADERS_MERGE_V

Line 979: FROM PO_HEADERS_MERGE_V

975: d_progress := 10;
976:
977: SELECT style_id
978: INTO l_style_id
979: FROM PO_HEADERS_MERGE_V
980: WHERE po_header_id = p_doc_id and draft_id = p_draft_id;
981:
982: RETURN l_style_id;
983:

Line 1081: PO_HEADERS_MERGE_V ph

1077: IF(l_type_lookup_code <> 'PLANNED') THEN
1078: select DISPLAY_NAME
1079: into l_style_display_name
1080: from PO_DOC_STYLE_LINES_TL TL,
1081: PO_HEADERS_MERGE_V ph
1082: where tl.LANGUAGE = nvl(p_language,
1083: USERENV('LANG'))
1084: and tl.style_id = ph.style_id
1085: and ph.po_header_id = p_doc_id

Line 1092: PO_HEADERS_MERGE_V ph

1088: ELSE
1089: SELECT TYPE_NAME
1090: INTO l_style_display_name
1091: FROM PO_DOCUMENT_TYPES_TL tl,
1092: PO_HEADERS_MERGE_V ph
1093: WHERE tl.language = NVL(p_language, USERENV('LANG'))
1094: AND ph.po_header_id = p_doc_id
1095: AND ph.draft_id = p_draft_id
1096: AND tl.document_subtype = 'PLANNED';