DBA Data[Home] [Help]

APPS.PO_SGD_PKG dependencies on PO_HEADERS_ALL_EXT_B

Line 144: p_object_name := 'PO_HEADERS_ALL_EXT_B';

140: p_object_name := 'PO_LINES_ALL_EXT_B';
141: p_pk1_column_name := 'PO_LINE_ID';
142: elsif p_doc_type = 'HEADER' then
143: p_attr_group_type := 'PO_HEADER_EXT_ATTRS';
144: p_object_name := 'PO_HEADERS_ALL_EXT_B';
145: p_pk1_column_name := 'PO_HEADER_ID';
146: end if;
147:
148: if (p_data_type = 'C' or p_data_type = 'A' ) then

Line 204: from po_headers_all_ext_b

200: WHERE POT.TEMPLATE_ID = POTU.TEMPLATE_ID
201: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
202: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
203: AND potu.attribute_group_id in (select distinct attr_group_id
204: from po_headers_all_ext_b
205: where po_header_id = p_headerId
206: and draft_id = p_draft_id and uda_template_id = potu.template_id
207: and attr_group_id = potu.attribute_group_id)
208: ORDER BY POTU.ATTRIBUTE_GROUP_SEQUENCE;