APPS.PV_SEED_DERIVED_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

   select to_char(aa.ordered_date,'yyyymmddhh24miss')
   from oe_order_headers_all aa, hz_cust_accounts b, pv_partner_profiles c
   where c.partner_id = pc_partner_id
   and c.partner_party_id = b.party_id
   and b.cust_account_id = aa.sold_to_org_id
   order by aa.ordered_date desc;

Line: 33

   select distinct a.inventory_item_id
   from oe_order_lines_all a, oe_order_headers_all aa, hz_cust_accounts b, pv_partner_profiles c
   where c.partner_id = pc_partner_id
   and c.partner_party_id = b.party_id and b.cust_account_id = aa.invoice_to_org_id
   and aa.ordered_date > add_months(sysdate, -12)
   and aa.header_id = a.header_id
   and a.flow_status_code = 'CLOSED'
   and a.actual_shipment_date is not null and a.line_category_code = 'ORDER'
   and a.cancelled_flag = 'N';

Line: 59

   select distinct a.inventory_item_id
   from ozf_sales_transactions_all a, hz_cust_accounts b, pv_partner_profiles c
   where c.partner_id = pc_partner_id
   and c.partner_party_id = b.party_id
   and b.cust_account_id = a.SOLD_FROM_CUST_ACCOUNT_ID
   and a.transfer_type = 'S'
   and a.transaction_date > add_months(sysdate, -12);