DBA Data[Home] [Help]

APPS.PO_EDA_DATATEMPLATE_PKG dependencies on PO_LINE_LOCATIONS_ALL_EXT_B

Line 39: p_object_name := 'PO_LINE_LOCATIONS_ALL_EXT_B';

35: l_sql varchar2(1000);
36: begin
37: if p_doc_type = 'SHIPMENT' then
38: p_attr_group_type := 'PO_SHIPMENTS_EXT_ATTRS';
39: p_object_name := 'PO_LINE_LOCATIONS_ALL_EXT_B';
40: p_pk1_column_name := 'LINE_LOCATION_ID';
41: elsif p_doc_type = 'LINES' then
42: p_attr_group_type := 'PO_LINE_EXT_ATTRS';
43: p_object_name := 'PO_LINES_ALL_EXT_B';

Line 538: from po_line_locations_all_ext_b

534: AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID
535: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
536: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
537: AND potu.attribute_group_id in (select distinct attr_group_id
538: from po_line_locations_all_ext_b
539: where line_location_id = p_line_location_id
540: and draft_id = DRAFTID
541: and attr_group_id = potu.attribute_group_id)
542: ORDER BY POTU.ATTRIBUTE_GROUP_SEQUENCE;