APPS.PO_CORE_S4 SQL Statements

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

Line: 23

    /* Delete the old notifications from the table. */

    /*  obsolete in R11
    DELETE FROM po_notifications pon
	WHERE pon.end_date_active < sysdate; */

Line: 31

    /* Delete the lot rows that were not processed */
    DELETE FROM rcv_lots_interface rli
        WHERE NOT EXISTS
            (SELECT rti.interface_transaction_id
             FROM   rcv_transactions_interface rti
             WHERE  rti.interface_transaction_id =
                    rli.interface_transaction_id);

Line: 42

    /* Delete the lot rows that were not processed */
    DELETE FROM rcv_serials_interface rsi
        WHERE NOT EXISTS
            (SELECT rti.interface_transaction_id
             FROM   rcv_transactions_interface rti
             WHERE  rti.interface_transaction_id =
                    rsi.interface_transaction_id);

Line: 88

    SELECT mp.PROJECT_REFERENCE_ENABLED,
           mp.PROJECT_CONTROL_LEVEL
    INTO   x_project_reference_enabled,
	   x_project_control_level
    FROM   mtl_parameters mp
    WHERE  mp.organization_id    = NVL(x_org_id, mp.organization_id)
    AND   mp.organization_code  = NVL(x_org_code, mp.organization_code);

Line: 158

	 SELECT po_wf_itemkey_s.NEXTVAL INTO p_event_key FROM dual;

Line: 165

	  l_parameter_list.delete;