DBA Data[Home] [Help]

APPS.PO_SGD_PKG dependencies on PO_LINE_LOCATIONS_ALL_EXT_B

Line 136: p_object_name := 'PO_LINE_LOCATIONS_ALL_EXT_B';

132: l_sql CLOB;
133: begin
134: if p_doc_type = 'SHIPMENT' then
135: p_attr_group_type := 'PO_SHIPMENTS_EXT_ATTRS';
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';

Line 400: from po_line_locations_all_ext_b

396: WHERE POT.TEMPLATE_ID = POTU.TEMPLATE_ID
397: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
398: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
399: AND potu.attribute_group_id in (select distinct attr_group_id
400: from po_line_locations_all_ext_b
401: where line_location_id = p_line_location_id
402: and draft_id = p_draft_Id and uda_template_id = potu.template_id
403: and attr_group_id = potu.attribute_group_id)
404: ORDER BY POTU.ATTRIBUTE_GROUP_SEQUENCE;