APPS.PO_MASS_CLOSE_PO_PVT dependencies on PO_DOCUMENT_TYPES

Line 58: l_doc_subtype po_document_types.document_subtype%TYPE;

54: l_po_num po_headers.segment1%TYPE;
55: l_rel_num po_releases.release_num%TYPE;
56: l_doc_id po_headers.po_header_id%TYPE;
57: l_type_code po_headers.type_lookup_code%TYPE;
58: l_doc_subtype po_document_types.document_subtype%TYPE;
59: l_release_id po_releases.po_release_id%TYPE;
60: l_doc_type po_document_types.type_name%TYPE;
61: l_org_id NUMBER;
62: result BOOLEAN;

Line 60: l_doc_type po_document_types.type_name%TYPE;

56: l_doc_id po_headers.po_header_id%TYPE;
57: l_type_code po_headers.type_lookup_code%TYPE;
58: l_doc_subtype po_document_types.document_subtype%TYPE;
59: l_release_id po_releases.po_release_id%TYPE;
60: l_doc_type po_document_types.type_name%TYPE;
61: l_org_id NUMBER;
62: result BOOLEAN;
63: l_return_code VARCHAR2(100);
64: l_commit_count NUMBER;

Line 170: po_document_types_vl pdt,

166: pdt.document_type_code,
167: pdt.document_subtype,
168: pdt.type_name
169: FROM po_headers poh,
170: po_document_types_vl pdt,
171: po_distributions pod,
172: po_line_locations pll
173: WHERE poh.type_lookup_code = pdt.document_subtype
174: AND poh.po_header_id = pod.po_header_id

Line 194: po_document_types_vl pdt

190: pdt.document_type_code,
191: pdt.document_subtype,
192: pdt.type_name
193: FROM po_headers poh,
194: po_document_types_vl pdt
195: WHERE poh.type_lookup_code = pdt.document_subtype
196: AND Nvl(pdt.document_type_code,''PA'') = ''PA''
197: AND Nvl(poh.authorization_status, ''INCOMPLETE'') IN (''APPROVED'',''REQUIRES REAPPROVAL'')
198: AND Nvl(poh.closed_code,''OPEN'') NOT IN (''CLOSED'',''FINALLY CLOSED'')

Line 208: po_document_types_vl pdt,

204: pdt.document_type_code,
205: pdt.document_subtype,
206: pdt.type_name
207: FROM po_headers poh,
208: po_document_types_vl pdt,
209: po_distributions pod,
210: po_line_locations pll
211: WHERE poh.type_lookup_code = pdt.document_subtype
212: AND poh.po_header_id = pod.po_header_id

Line 229: po_document_types_vl pdt

225: poh.po_header_id,
226: pdt.document_type_code,
227: pdt.document_subtype,
228: pdt.type_name FROM po_headers poh,
229: po_document_types_vl pdt
230: WHERE poh.type_lookup_code = pdt.document_subtype
231: AND Nvl(pdt.document_type_code,''PA'') = ''PA''
232: AND Nvl(poh.authorization_status, ''INCOMPLETE'') IN (''APPROVED'',''REQUIRES REAPPROVAL'')
233: AND Nvl(poh.closed_code,''OPEN'') NOT IN (''CLOSED'',''FINALLY CLOSED'')

Line 431: po_document_types_vl pdt,

427: pdt.document_subtype,
428: pdt.type_name
429: FROM po_releases por,
430: po_headers poh,
431: po_document_types_vl pdt,
432: po_distributions_all pod,
433: po_line_locations_all pll
434: WHERE por.po_header_id = poh.po_header_id
435: AND por.po_header_id = pod.po_header_id