DBA Data[Home] [Help]

APPS.PO_SGD_PKG dependencies on PO_LINES_ALL_EXT_B

Line 140: p_object_name := 'PO_LINES_ALL_EXT_B';

136: p_object_name := 'PO_LINE_LOCATIONS_ALL_EXT_B';
137: p_pk1_column_name := 'LINE_LOCATION_ID';
138: elsif p_doc_type = 'LINES' then
139: p_attr_group_type := 'PO_LINE_EXT_ATTRS';
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';

Line 301: from po_lines_all_ext_b

297: WHERE POT.TEMPLATE_ID = POTU.TEMPLATE_ID
298: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
299: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
300: AND potu.attribute_group_id in (select distinct attr_group_id
301: from po_lines_all_ext_b
302: where po_line_id = p_po_line_id
303: and draft_id = p_draft_Id
304: and attr_group_id = potu.attribute_group_id and uda_template_id = potu.template_id
305: and pk1_value IS NULL)