[Home] [Help]
4032: po_requisition_headers = fp_req_header_rows,
4033: po_vendors = fp_vendor_rows,
4034: po_approved_supplier_list = fp_po_asl_rows,
4035: po_asl_attributes = fp_po_asl_attr_rows,
4036: po_asl_documents = fp_po_asl_doc_rows,
4037: chv_authorizations = fp_chv_auth_rows,
4038: chv_cum_adjustments = fp_chv_cum_adj_rows,
4039: chv_cum_periods = fp_chv_cum_rows,
4040: chv_horizontal_schedules = fp_chv_hor_rows,
6091: END IF;
6092:
6093: -- delete po_asl_docments
6094:
6095: delete from po_asl_documents pad where
6096: exists (select null from po_asl_attributes paa,
6097: po_purge_vendor_list pvl
6098: where pvl.vendor_id = paa.vendor_id
6099: and pvl.double_check_flag = 'Y'
6509: po_vendors = nvl(po_vendors, 0) - vendor_rows,
6510: po_receipts = nvl(po_receipts, 0) - shipment_line_rows,
6511: po_approved_supplier_list = nvl(po_approved_supplier_list,0) - po_asl_rows,
6512: po_asl_attributes = nvl(po_asl_attributes,0) - po_asl_attr_rows,
6513: po_asl_documents = nvl(po_asl_documents,0) - po_asl_doc_rows,
6514: chv_authorizations = nvl(chv_authorizations,0) - chv_auth_rows,
6515: chv_cum_adjustments = nvl(chv_cum_adjustments,0) - chv_cum_adj_rows,
6516: chv_cum_periods = nvl(chv_cum_periods,0) - chv_cum_rows,
6517: chv_horizontal_Schedules = nvl(chv_horizontal_schedules,0) - chv_hor_rows,