APPS.PO_MASS_CLOSE_PO_PVT dependencies on PO_HEADERS

Line 55: l_po_num po_headers.clm_document_number%TYPE;

51: stmt_po VARCHAR2(6000);
52: stmt_rel VARCHAR2(4000);
53: stmt_pa VARCHAR2(4000); --Bug 10371162
54: po_num_type VARCHAR2(100);
55: l_po_num po_headers.clm_document_number%TYPE;
56: l_rel_num po_releases.release_num%TYPE;
57: l_doc_id po_headers.po_header_id%TYPE;
58: l_type_code po_headers.type_lookup_code%TYPE;
59: l_doc_subtype po_document_types.document_subtype%TYPE;

Line 57: l_doc_id po_headers.po_header_id%TYPE;

53: stmt_pa VARCHAR2(4000); --Bug 10371162
54: po_num_type VARCHAR2(100);
55: l_po_num po_headers.clm_document_number%TYPE;
56: l_rel_num po_releases.release_num%TYPE;
57: l_doc_id po_headers.po_header_id%TYPE;
58: l_type_code po_headers.type_lookup_code%TYPE;
59: l_doc_subtype po_document_types.document_subtype%TYPE;
60: l_release_id po_releases.po_release_id%TYPE;
61: l_doc_type po_document_types.type_name%TYPE;

Line 58: l_type_code po_headers.type_lookup_code%TYPE;

54: po_num_type VARCHAR2(100);
55: l_po_num po_headers.clm_document_number%TYPE;
56: l_rel_num po_releases.release_num%TYPE;
57: l_doc_id po_headers.po_header_id%TYPE;
58: l_type_code po_headers.type_lookup_code%TYPE;
59: l_doc_subtype po_document_types.document_subtype%TYPE;
60: l_release_id po_releases.po_release_id%TYPE;
61: l_doc_type po_document_types.type_name%TYPE;
62: l_org_id NUMBER;

Line 170: FROM po_headers poh,

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

Line 195: FROM po_headers poh,

191: poh.po_header_id,
192: pdt.document_type_code,
193: pdt.document_subtype,
194: pdt.type_name
195: FROM po_headers poh,
196: po_document_types_vl pdt
197: WHERE poh.type_lookup_code = pdt.document_subtype
198: AND Nvl(pdt.document_type_code,''PA'') = ''PA''
199: AND Nvl(poh.authorization_status, ''INCOMPLETE'')

Line 210: FROM po_headers poh,

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

Line 233: pdt.type_name FROM po_headers poh,

229: stmt_pa := ' SELECT poh.segment1 PO_Number,
230: poh.po_header_id,
231: pdt.document_type_code,
232: pdt.document_subtype,
233: pdt.type_name FROM po_headers poh,
234: po_document_types_vl pdt
235: WHERE poh.type_lookup_code = pdt.document_subtype
236: AND Nvl(pdt.document_type_code,''PA'') = ''PA''
237: AND Nvl(poh.authorization_status, ''INCOMPLETE'')

Line 504: po_headers poh,

500: pdt.document_type_code,
501: pdt.document_subtype,
502: pdt.type_name
503: FROM po_releases por,
504: po_headers poh,
505: po_document_types_vl pdt
506: WHERE por.po_header_id = poh.po_header_id
507: AND pdt.document_type_code = ''RELEASE''
508: AND pdt.document_subtype = por.release_type