DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on PO_ASL_DOCUMENTS

Line 4540: po_asl_documents = fp_po_asl_doc_rows,

4536: po_requisition_headers = fp_req_header_rows,
4537: po_vendors = fp_vendor_rows,
4538: po_approved_supplier_list = fp_po_asl_rows,
4539: po_asl_attributes = fp_po_asl_attr_rows,
4540: po_asl_documents = fp_po_asl_doc_rows,
4541: chv_authorizations = fp_chv_auth_rows,
4542: chv_cum_adjustments = fp_chv_cum_adj_rows,
4543: chv_cum_periods = fp_chv_cum_rows,
4544: chv_horizontal_schedules = fp_chv_hor_rows,

Line 6671: delete from po_asl_documents pad where

6667: END IF;
6668:
6669: -- delete po_asl_docments
6670:
6671: delete from po_asl_documents pad where
6672: exists (select null from po_asl_attributes paa,
6673: po_purge_vendor_list pvl
6674: where pvl.vendor_id = paa.vendor_id
6675: and pvl.double_check_flag = 'Y'

Line 7203: po_asl_documents = nvl(po_asl_documents,0) - po_asl_doc_rows,

7199: po_vendors = nvl(po_vendors, 0) - vendor_rows,
7200: po_receipts = nvl(po_receipts, 0) - shipment_line_rows,
7201: po_approved_supplier_list = nvl(po_approved_supplier_list,0) - po_asl_rows,
7202: po_asl_attributes = nvl(po_asl_attributes,0) - po_asl_attr_rows,
7203: po_asl_documents = nvl(po_asl_documents,0) - po_asl_doc_rows,
7204: chv_authorizations = nvl(chv_authorizations,0) - chv_auth_rows,
7205: chv_cum_adjustments = nvl(chv_cum_adjustments,0) - chv_cum_adj_rows,
7206: chv_cum_periods = nvl(chv_cum_periods,0) - chv_cum_rows,
7207: chv_horizontal_Schedules = nvl(chv_horizontal_schedules,0) - chv_hor_rows,