DBA Data[Home] [Help]

APPS.M4R_7B5_OSFM_PKG dependencies on PO_LINE_TYPES

Line 118: FROM po_line_types

114: FROM po_lines_archive_all
115: WHERE po_header_id = l_po_header_id
116: AND line_type_id IN
117: ( SELECT line_type_id
118: FROM po_line_types
119: WHERE outside_operation_flag ='Y'
120: )
121: AND ROWNUM < 2;
122:

Line 291: FROM po_line_types

287: FROM po_lines_all l, po_line_locations_all ll, po_distributions_all d
288: WHERE l.po_header_id = l_po_header_id
289: AND l.line_type_id IN (
290: SELECT line_type_id
291: FROM po_line_types
292: WHERE outside_operation_flag ='Y'
293: )
294: AND ll.po_line_id = l.po_line_id
295: AND (ll.po_release_id = l_po_rel_id OR ll.po_release_id IS NULL)