DBA Data[Home] [Help]

APPS.PO_QUOTES_SV dependencies on PO_ASL_DOCUMENTS

Line 69: ** CMOK: If ASL installed, use po_asl_documents table.

65: ** Verify the Quotation is not used in autosource rules.
66: ** If it is NOT, verify it is not on a req line.
67: ** If it is, display message and prevent delete.
68: **
69: ** CMOK: If ASL installed, use po_asl_documents table.
70: */
71:
72:
73: SELECT MAX('N')

Line 75: FROM po_asl_documents pad

71:
72:
73: SELECT MAX('N')
74: INTO X_delete_test
75: FROM po_asl_documents pad
76: WHERE pad.document_header_id = X_po_header_id;
77:
78: IF (nvl(X_delete_test,'Y') = 'Y') THEN
79: /*

Line 210: FROM po_asl_documents pad

206:
207: x_progress := '040';
208: SELECT count(*)
209: INTO x_sourced
210: FROM po_asl_documents pad
211: WHERE pad.DOCUMENT_HEADER_ID = X_po_header_id
212: AND pad.DOCUMENT_LINE_ID = X_po_line_id;
213:
214: