eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DATATEMPLATE_PKG dependencies on PO_LINE_LOCATIONS_ALL_EXT_B

Line 190: p_object_name := 'PO_LINE_LOCATIONS_ALL_EXT_B';

186: l_sql varchar2(1000);
187: begin
188: if p_doc_type = 'SHIPMENT' then
189: p_attr_group_type := 'PO_SHIPMENTS_EXT_ATTRS';
190: p_object_name := 'PO_LINE_LOCATIONS_ALL_EXT_B';
191: p_pk1_column_name := 'LINE_LOCATION_ID';
192: elsif p_doc_type = 'LINES' then
193: p_attr_group_type := 'PO_LINE_EXT_ATTRS';
194: p_object_name := 'PO_LINES_ALL_EXT_B';

Line 355: from po_line_locations_all_ext_b

351: WHERE POT.TEMPLATE_ID = POTU.TEMPLATE_ID
352: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
353: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
354: AND potu.attribute_group_id in (select distinct attr_group_id
355: from po_line_locations_all_ext_b
356: where line_location_id = p_line_location_id
357: and draft_id = p_draft_Id and uda_template_id = potu.template_id
358: and attr_group_id = potu.attribute_group_id)
359: ORDER BY POTU.ATTRIBUTE_GROUP_SEQUENCE;

Line 877: || 'FROM PO_LINE_LOCATIONS_All_ext_b WHERE line_location_id IN '

873: l_draftId := draftId;
874: end if;
875:
876: l_sql_d := '(SELECT COUNT(NVL( ' || l_col_name || ' , ''N'')) '
877: || 'FROM PO_LINE_LOCATIONS_All_ext_b WHERE line_location_id IN '
878: || l_sql_o
879: || ' and draft_id = :2 and attr_group_id =:3 AND '
880: || ' DECODE( NVL(' || l_col_name || ', ''N''), ''OSP'', ''Origin'', ''OAL'', ''Origin'',
881: NVL(' || l_col_name || ', ''N'')) <> :4)';