APPS.PO_MASS_CLOSE_PO_PVT dependencies on PO_HEADERS

Line 54: l_po_num po_headers.segment1%TYPE;

50: close_rel g_close_rel;
51: stmt_po VARCHAR2(4000);
52: stmt_rel VARCHAR2(4000);
53: po_num_type VARCHAR2(100);
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;

Line 56: l_doc_id po_headers.po_header_id%TYPE;

52: stmt_rel VARCHAR2(4000);
53: po_num_type VARCHAR2(100);
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;

Line 57: l_type_code po_headers.type_lookup_code%TYPE;

53: po_num_type VARCHAR2(100);
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;

Line 169: FROM po_headers poh,

165: poh.po_header_id,
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

Line 193: FROM po_headers poh,

189: poh.po_header_id,
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'')

Line 207: FROM po_headers poh,

203: poh.po_header_id,
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

Line 228: pdt.type_name FROM po_headers poh,

224: SELECT poh.segment1 PO_Number,
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'')

Line 430: po_headers poh,

426: pdt.document_type_code,
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